Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
CUSTNMBR | Customer Number |
String | 16 | View | |
DSCRIPTN | Description |
String | 32 | View | |
CURNCYID | Currency ID |
String | 16 | View | |
CURRNIDX | Currency Index |
Integer | 2 | View | |
DOCDATE | Document Date |
Date | 4 | View | |
DOCNUMBR | Document Number |
String | 22 | View | |
DOCPRFIX | Document Prefix |
String | 4 | View | |
RMDTYPAL | RM Document Type-All 0 = Reserved for balance carried forward records |
Integer | 2 | View | |
DOCDESCR | Document Description |
String | 32 | View | |
PORDNMBR | Purchase Order Number |
String | 22 | View | |
DOCAMNT | Document Amount |
Currency | 10 | View | |
Credit_Amount_String_30 | Credit Amount String 30 |
String | 32 | View | |
DEBITAMT | Debit Amount |
Currency | 10 | View | |
BALNCDUE | Balance Due |
Currency | 10 | View | |
AGNGBUKT | Aging Bucket |
Integer | 2 | View | |
CRDTAMNT | Credit Amount |
Currency | 10 | View | |
CHCUMNUM | Child Customer Number |
String | 16 | View | |
CHCUMNAM | Child Customer Name |
String | 66 | View | |
CURTRXAM | Current Trx Amount |
Currency | 10 | View | |
AMNTPAID | Amount Paid |
Currency | 10 | View | |
RNNMBR | Run Number |
Long Integer | 4 | View | |
SEQNUMBR | Sequence Number |
Long Integer | 4 | View | |
USERID | User ID |
String | 16 | View | |
Process_Index | Process Index |
Long Integer | 4 | View |