Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
ITEMNMBR | Item Number |
String | 32 | View | |
SEQNUMBR | Sequence Number |
Long Integer | 4 | View | |
DOCDATE | Document Date |
Date | 4 | View | |
GLPOSTDT | GL Posting Date |
Date | 4 | View | |
DOCNUMBR | Document Number |
String | 22 | View | |
DOCTYPE | Document Type |
Integer | 2 | View | |
LOCNCODE | Location Code |
String | 12 | View | |
RCPTNMBR | Receipt Number |
String | 22 | View | |
RCTSEQNM | Receipt SEQ Number |
Long Integer | 4 | View | |
PCHSRCTY | Purchase Receipt Type |
Integer | 2 | View | |
QTYTYPE | QTY Type 1 = On Hand |
Integer | 2 | View | |
UOFM | U Of M |
String | 10 | View | |
TRXQTYInBase | TRX QTY In Base |
Currency | 10 | View | |
TRXQTY | TRX QTY |
Currency | 10 | View | |
VARIANCEQTY | Variance Qty |
Currency | 10 | View | |
UNITCOST | Unit Cost |
Currency | 10 | View | |
EXTDCOST | Extended Cost |
Currency | 10 | View | |
DECPLQTY | Decimal Places QTYS |
Integer | 2 | View | |
DECPLCUR | Decimal Places Currency |
Integer | 2 | View | |
IsOverrideReceipt | IsOverrideReceipt |
Boolean | 2 | View | |
IsOverrideRelieved | IsOverrideRelieved |
Boolean | 2 | View | |
OverrideRelievedDate | OverrideRelievedDate |
Date | 4 | View | |
RCPTNMBR1 | Originating Revalued Receipt Number |
String | 22 | View | |
HSTMODUL | History Module |
String | 4 | View | |
ORTRXSRC | Originating TRX Source |
String | 14 | View | |
LNSEQNBR | Line SEQ Number |
Currency | 10 | View | |
LNITMSEQ | Line Item Sequence |
Long Integer | 4 | View | |
CMPNTSEQ | Component Sequence |
Long Integer | 4 | View | |
SRCRFRNCNMBR | Source Reference Number |
String | 32 | View | |
VENDORID | Vendor ID |
String | 16 | View | |
PONUMBER | PO Number |
String | 18 | View | |
TRXREFERENCE | Transaction Reference |
Integer | 2 | View | |
VCTNMTHD | Valuation Method 1. FIFO Perpetual |
Integer | 2 | View | |
IVIVINDX | IV IV Index |
Long Integer | 4 | View | |
IVIVOFIX | IV IV Offset Index |
Long Integer | 4 | View | |
JRNENTRY | Journal Entry |
Long Integer | 4 | View | |
TRXSORCE | TRX Source |
String | 14 | View | |
DEBITAMT | Debit Amount |
Currency | 10 | View | |
CRDTAMNT | Credit Amount |
Currency | 10 | View | |
DATE1 | Date |
Date | 4 | View | |
TIME1 | Time |
Time | 4 | View |