| COMMNTID |
char(15)
''
|
Comment ID...(more) Join Now
|
SOP10100.COMMNTID
|
|
join ... more text available
|
| SETUPKEY |
smallint
0
|
Setup Key...(more) Join Now
|
IV40100.SETUPKEY
|
|
|
| DPYITMCS |
tinyint
0
|
|
|
|
|
| DQTYSWAR |
tinyint
0
|
|
|
|
|
| TRKVDTRX |
tinyint
0
|
|
|
|
|
| CALCKITC |
tinyint
0
|
|
|
|
|
| NEWRATES |
tinyint
0
|
|
|
|
|
| TRMSTNUM |
tinyint
0
|
Indicates ...(more) Join Now
|
|
|
|
| NXTMSTNO |
int
0
|
|
|
|
|
| QUOTE |
tinyint
0
|
|
|
|
|
| PRDER |
tinyint
0
|
|
|
|
|
| INVORETU |
tinyint
0
|
|
|
|
|
| ACDSTRBN |
tinyint
0
|
|
|
|
|
| LOCNCODE |
char(11)
''
|
Location C...(more) Join Now
|
RM00102.LOCNCODE
|
|
join ... more text available
|
| CHEKBKID |
char(15)
''
|
Checkbook ID Checkbook this transaction affects
|
SY30500.CHEKBKID
|
|
join ... more text available
|
| DFQTYSOP |
smallint
0
|
Default Qt...(more) Join Now
|
|
|
|
| QUODOCID |
char(15)
''
|
|
|
|
|
| ORDDOCID |
char(15)
''
|
Field Type...(more) Join Now
|
SVC00203.ORDDOCID
|
|
|
| BACDOCID |
char(15)
''
|
|
|
|
|
| INVDOCID |
char(15)
''
|
|
|
|
|
| RETDOCID |
char(15)
''
|
Field Type...(more) Join Now
|
SVC00203.RETDOCID
|
|
|
| DECPLQTY |
smallint
0
|
Decimal Pl...(more) Join Now
|
|
|
|
| DECPLCUR |
smallint
0
|
Number of ...(more) Join Now
|
|
|
|
| USEACFRM |
smallint
0
|
Use Postin...(more) Join Now
|
|
|
|
| USEADVTX |
smallint
0
|
Use Advanc...(more) Join Now
|
|
|
|
| TAXSCHID |
char(15)
''
|
Tax Schedu...(more) Join Now
|
|
|
join ... more text available
|
| NONIVTXB |
smallint
0
|
|
|
|
|
| NONIVSCH |
char(15)
''
|
Non IV Ite...(more) Join Now
|
|
|
|
| FRGTTXBL |
smallint
0
|
Freight Ta...(more) Join Now
|
|
|
|
| FRTSCHID |
char(15)
''
|
Freight Sc...(more) Join Now
|
|
|
join ... more text available
|
| MISCTXBL |
smallint
0
|
Misc Taxab...(more) Join Now
|
|
|
|
| MSCSCHID |
char(15)
''
|
Misc Sched...(more) Join Now
|
|
|
join ... more text available
|
| MPACKSLP |
smallint
0
|
|
|
|
|
| MPICKTIC |
smallint
0
|
|
|
|
|
| PriceLevelWarning |
smallint
0
|
|
|
|
|
| SOPALLOW_1 |
tinyint
0
|
|
|
|
|
| SOPALLOW_2 |
tinyint
0
|
|
|
|
|
| SOPALLOW_3 |
tinyint
0
|
|
|
|
|
| SOPALLOW_4 |
tinyint
0
|
|
|
|
|
| SOPALLOW_5 |
tinyint
0
|
|
|
|
|
| SOPALLOW_6 |
tinyint
0
|
|
|
|
|
| SOPALLOW_7 |
tinyint
0
|
|
|
|
|
| SOPALLOW_8 |
tinyint
0
|
|
|
|
|
| SOPALLOW_9 |
tinyint
0
|
|
|
|
|
| SOPALLOW_10 |
tinyint
0
|
|
|
|
|
| SOPPSSWD_1 |
char(11)
''
|
|
|
|
|
| SOPPSSWD_2 |
char(11)
''
|
|
|
|
|
| SOPPSSWD_3 |
char(11)
''
|
|
|
|
|
| SOPPSSWD_4 |
char(11)
''
|
|
|
|
|
| SOPPSSWD_5 |
char(11)
''
|
|
|
|
|
| SOPPSSWD_6 |
char(11)
''
|
|
|
|
|
| SOPPSSWD_7 |
char(11)
''
|
|
|
|
|
| SOPPSSWD_8 |
char(11)
''
|
|
|
|
|
| SOPPSSWD_9 |
char(11)
''
|
|
|
|
|
| SOPPSSWD_10 |
char(11)
''
|
|
|
|
|
| IVCDSTCK |
binary(4)
0
|
|
|
|
|
| NUMOFTRX |
int
0
|
Number Of ...(more) Join Now
|
|
|
|
| USRDFPR1 |
char(15)
''
|
|
|
|
|
| USRDRPR2 |
char(15)
''
|
|
|
|
|
| USRDRPR3 |
char(15)
''
|
|
|
|
|
| USRDRPR4 |
char(15)
''
|
|
|
|
|
| USRDRPR5 |
char(15)
''
|
|
|
|
|
| USRDRPR6 |
char(15)
''
|
|
|
|
|
| USRDRPR7 |
char(15)
''
|
|
|
|
|
| USRDRPR8 |
char(15)
''
|
|
|
|
|
| USRDRPR9 |
char(15)
''
|
|
|
|
|
| USRDRP10 |
char(15)
''
|
|
|
|
|
| USRDRP11 |
char(15)
''
|
|
|
|
|
| USRDRP12 |
char(15)
''
|
|
|
|
|
| USRDFPR13 |
char(15)
''
|
|
|
|
|
| USRDFPR14 |
char(15)
''
|
|
|
|
|
| USRDFPR15 |
char(15)
''
|
|
|
|
|
| USRDFPR16 |
char(15)
''
|
|
|
|
|
| USRDFPR17 |
char(15)
''
|
|
|
|
|
| CREATDDT |
datetime
'1/1/1900'
|
Created Da...(more) Join Now
|
RM00101.CREATDDT
|
|
|
| MODIFDT |
datetime
'1/1/1900'
|
Date the r...(more) Join Now
|
|
|
|
| REQSHIP |
smallint
0
|
|
|
|
|
| REQDAYS |
smallint
0
|
|
|
|
|
| SITEPREF |
smallint
0
|
|
|
|
|
| PREFSITE |
char(11)
''
|
|
|
|
|
| REQDATEPO |
smallint
0
|
|
|
|
|
| Required_Days |
smallint
0
|
|
|
|
|
| UMDEFAULT |
smallint
0
|
|
|
|
|
| COMBONPO |
tinyint
0
|
|
|
|
|
| TXBASECS |
tinyint
0
|
|
|
|
|
| USEORGUC |
tinyint
0
|
|
|
|
|
| Prices_Not_Required_In_Pr |
tinyint
0
|
|
|
|
|
| PasswordUpper |
char(11)
''
|
|
|
|
|
| Convert_Functional_Price |
tinyint
0
|
|
|
|
|
| INDVPICKTICKETSORT |
smallint
0
|
|
|
|
|
| PRINTAVAILABLEBINS |
smallint
0
|
|
|
|
|
| FODOCID |
char(15)
''
|
|
|
|
|
| CombineDropshipSOLines |
tinyint
0
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
| CombineDropshipSODocs |
tinyint
0
|
|
|
|
|