| USERID |
char
|
The user t...(more) Join Now
|
|
|
join ... more text available
|
| SEQNUMBR |
int
|
Sequence N...(more) Join Now
|
HR2EMP02.SEQNUMBR
|
|
|
| CUSTNMBR |
char
|
Customer N...(more) Join Now
|
PA01101.CUSTNMBR
|
|
join ... more text available
|
| CPRCSTNM |
char
|
|
|
|
|
| CUSTNAME |
char
|
|
|
|
|
| DOCNUMBR |
char
|
Document N...(more) Join Now
|
RM20102.DOCNUMBR
|
|
|
| RMDTYPAL |
smallint
|
RM Documen...(more) Join Now
|
RM20102.RMDTYPAL
|
|
|
| DUEDATE |
datetime
|
Due Date T...(more) Join Now
|
MOP1071.DUEDATE
|
|
|
| DOCDATE |
datetime
|
The date a...(more) Join Now
|
RM20101.DOCDATE
|
|
|
| ORTRXAMT |
numeric
|
|
|
|
|
| CURTRXAM |
numeric
|
|
|
|
|
| SLSAMNT |
numeric
|
Sales Amou...(more) Join Now
|
ICJC9000.SLSAMNT
|
|
|
| COSTAMNT |
numeric
|
Cost Amoun...(more) Join Now
|
ICJC9000.COSTAMNT
|
|
|
| FRTAMNT |
numeric
|
Freight Am...(more) Join Now
|
PA11801.FRTAMNT
|
|
|
| MISCAMNT |
numeric
|
Misc Amoun...(more) Join Now
|
ICJC9000.MISCAMNT
|
|
|
| TAXAMNT |
numeric
|
Tax Amount...(more) Join Now
|
PA11801.TAXAMNT
|
|
|
| CASHAMNT |
numeric
|
Cash Amoun...(more) Join Now
|
PTE30500.CASHAMNT
|
|
|
| DISTKNAM |
numeric
|
Discount T...(more) Join Now
|
RM20102.DISTKNAM
|
|
|
| DISAVAMT |
numeric
|
Discount A...(more) Join Now
|
ICJC9000.DISAVAMT
|
|
|
| DISCRTND |
numeric
|
Discount R...(more) Join Now
|
ICJC9000.DISCRTND
|
|
|
| DISCDATE |
datetime
|
Discount D...(more) Join Now
|
PTE30500.DISCDATE
|
|
|
| DSCDLRAM |
numeric
|
|
|
|
|
| DSCPCTAM |
smallint
|
Discount P...(more) Join Now
|
PA01101.DSCPCTAM
|
|
|
| TRXDSCRN |
char
|
|
|
|
|
| DOCDESCR |
char
|
Document D...(more) Join Now
|
ICJC9000.DOCDESCR
|
|
|
| DOCHDR |
char
|
|
|
|
|
| DOCHDR2 |
char
|
|
|
|
|
| CSPORNBR |
char
|
|
|
|
|
| SLPRSNID |
char
|
Salesperso...(more) Join Now
|
PA01101.SLPRSNID
|
|
join ... more text available
|
| SLSTERCD |
char
|
|
|
|
|
| PPSAMDED |
numeric
|
PPS Amount...(more) Join Now
|
ICJC9001.PPSAMDED
|
|
|
| GSTDSAMT |
numeric
|
GST Discou...(more) Join Now
|
ICJC9001.GSTDSAMT
|
|
|
| AGNGBUKT |
smallint
|
|
|
|
|
| VOIDSTTS |
smallint
|
1 = Voided...(more) Join Now
|
PP100100.VOIDSTTS
|
|
|
| VOIDDATE |
datetime
|
|
|
|
|
| TAXSCHID |
char
|
|
|
|
join ... more text available
|
| CURNCYID |
char
|
Currency I...(more) Join Now
|
RM20102.CURNCYID
|
|
join ... more text available
|
| PYMTRMID |
char
|
Payment Te...(more) Join Now
|
RM50105.PYMTRMID
|
|
SY033... more text available
|
| SHIPMTHD |
char
|
|
|
|
join ... more text available
|
| TRDISAMT |
numeric
|
Trade Disc...(more) Join Now
|
PA11801.TRDISAMT
|
|
|
| SLSCHDID |
char
|
|
|
|
|
| FRTSCHID |
char
|
Freight Sc...(more) Join Now
|
RM30101.FRTSCHID
|
|
join ... more text available
|
| MSCSCHID |
char
|
|
|
|
join ... more text available
|
| APLYWITH |
tinyint
|
|
|
|
|
| SALEDATE |
datetime
|
|
|
|
|
| DCSTATUS |
smallint
|
|
|
|
|
| CURRNIDX |
smallint
|
Currency I...(more) Join Now
|
RM20102.CURRNIDX
|
|
join ... more text available
|
| ORCASAMT |
numeric
|
Originatin...(more) Join Now
|
PTE30500.ORCASAMT
|
|
|
| ORCSTAMT |
numeric
|
|
|
|
|
| ORCTRXAM |
numeric
|
|
|
|
|
| ORDAVAMT |
numeric
|
|
|
|
|
| ORDDLRAT |
numeric
|
Originatin...(more) Join Now
|
PTE30500.ORDDLRAT
|
|
|
| ORDISRTD |
numeric
|
|
|
|
|
| ORDISTKN |
numeric
|
Orig Disco...(more) Join Now
|
RM20102.ORDISTKN
|
|
|
| ORFRTAMT |
numeric
|
Originatin...(more) Join Now
|
PTE30500.ORFRTAMT
|
|
|
| ORMISCAMT |
numeric
|
|
|
|
|
| ORORGTRX |
numeric
|
|
|
|
|
| ORSLSAMT |
numeric
|
|
|
|
|
| ORTAXAMT |
numeric
|
Originatin...(more) Join Now
|
PTE30501.ORTAXAMT
|
|
|
| ORTDISAM |
numeric
|
|
|
|
|
| UPSZONE |
char
|
|
|
|
|
| CNTCPRSN |
char
|
Contact Pe...(more) Join Now
|
PA01101.CNTCPRSN
|
|
|
| ADDRESS1 |
char
|
|
|
|
|
| ADDRESS2 |
char
|
|
|
|
|
| ADDRESS3 |
char
|
|
|
|
|
| COUNTRY |
char
|
|
|
|
|
| CITY |
char
|
|
|
|
|
| STATE |
char
|
|
|
|
|
| ZIPCODE |
char
|
|
|
|
|
| PHONE1 |
char
|
|
|
|
|
| PHONE2 |
char
|
|
|
|
|
| PHONE3 |
char
|
|
|
|
|
| FAX |
char
|
|
|
|
|
| TXRGNNUM |
char
|
Tax Regist...(more) Join Now
|
EDCVAT41.TXRGNNUM
|
|
|
| CORRCTN |
tinyint
|
Correction...(more) Join Now
|
SOP10100.CORRCTN
|
|
|
| SIMPLIFD |
tinyint
|
|
|
|
|
| BACHNUMB |
char
|
Batch Numb...(more) Join Now
|
|
|
join ... more text available
|
| NOTEINDX |
numeric
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| DISPCASHAMNT |
numeric
|
|
|
|
|
| DISPCOSTAMNT |
numeric
|
|
|
|
|
| DISPCURTRXAM |
numeric
|
|
|
|
|
| DISPDISAVAMT |
numeric
|
|
|
|
|
| DISPDSCDLRAM |
numeric
|
|
|
|
|
| DISPDISCRTND |
numeric
|
|
|
|
|
| DISPDISTKNAM |
numeric
|
|
|
|
|
| DISPFRTAMNT |
numeric
|
|
|
|
|
| DISPMISCAMNT |
numeric
|
|
|
|
|
| DISPORTRXAMT |
numeric
|
|
|
|
|
| DISPSLSAMNT |
numeric
|
|
|
|
|
| DISPTAXAMNT |
numeric
|
|
|
|
|
| DISPTRDISAMT |
numeric
|
|
|
|
|
| DISPCURRNIDX |
smallint
|
|
|
|
|
| XCHGRATE |
numeric
|
Exchange R...(more) Join Now
|
MC00100.XCHGRATE
|
|
|
| CCode |
char
|
|
|
|
|
| DIRECTDEBIT |
tinyint
|
|
|
|
|
| EFTFLAG |
tinyint
|
|
|
|
|
| Email_Type |
smallint
|
1 – ...(more) Join Now
|
RM00106.Email_Type
|
|
|
| ASI_Legend1 |
char
|
|
|
|
|
| ASI_Legend2 |
char
|
|
|
|
|
| ASI_Legend3 |
char
|
|
|
|
|
| ASI_Legend4 |
char
|
|
|
|
|
| ASI_Legend5 |
char
|
|
|
|
|
| ASI_Legend6 |
char
|
|
|
|
|
| ASI_RMDebitType |
tinyint
|
|
|
|
|
| ASI_ShowExchangeRate |
tinyint
|
|
|
|
|
| ASI_TaxHeading1 |
char
|
|
|
|
|
| ASI_TaxHeading2 |
char
|
|
|
|
|
| ASI_TaxHeading3 |
char
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|