IVC30102 - Invoicing Transaction Amounts History
SQL Query Builder
50 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| DOCTYPE | smallint 0 | ||||
Document Type (Payables) values (7) 1 = Invoice2 = Finance Charge3 = Miscellaneous Charge4 = Return5 = Credit Memo6 = Payment7 = Scheduled Payment | |||||
| INVCNMBR | char(21) '' | ||||
| LNITMSEQ | int 0 | ||||
| CMPNTSEQ | int 0 | ||||
| NONINVEN | smallint 0 | ||||
| ITEMNMBR | char(31) '' | ||||
| DECPLCUR | smallint 0 | ||||
| DECPLQTY | smallint 0 | ||||
| ITMTSHID | char(15) '' | ||||
| IVITMTXB | smallint 0 | ||||
| QUANTITY | numeric(19,5) 0.00 | ||||
| QTYINSVC | numeric(19,5) 0.00 | ||||
| QTYINUSE | numeric(19,5) 0.00 | ||||
| QTYDMGED | numeric(19,5) 0.00 | ||||
| QTYRTRND | numeric(19,5) 0.00 | ||||
| QTYONHND | numeric(19,5) 0.00 | ||||
| EXTQTYSEL | numeric(19,5) 0.00 | ||||
| UOFM | char(9) '' | ||||
| QTYBSUOM | numeric(19,5) 0.00 | ||||
| UNITCOST | numeric(19,5) 0.00 | ||||
| EXTDCOST | numeric(19,5) 0.00 | ||||
| ATYALLOC | numeric(19,5) 0.00 | ||||
| LOCNCODE | char(11) '' | ||||
| MRKDNTYP | smallint 0 | ||||
| MRKDNAMT | numeric(19,5) 0.00 | ||||
| MRKDNPCT | smallint 0 | ||||
| PRCLEVEL | char(11) '' | ||||
| XTNDPRCE | numeric(19,5) 0.00 | ||||
| UNITPRCE | numeric(19,5) 0.00 | ||||
| TAXAMNT | numeric(19,5) 0.00 | ||||
| BKTSLSAM | numeric(19,5) 0.00 | ||||
| TXBTXAMT | numeric(19,5) 0.00 | ||||
| SLPRSNID | char(15) '' | ||||
| SALSTERR | char(15) '' | ||||
| DSCRIPTN | char(31) '' | ||||
| ITEMDESC | char(101) '' | ||||
| EXPTSHIP | datetime '1/1/1900' | ||||
| ACTLSHIP | datetime '1/1/1900' | ||||
| ReqShipDate | datetime '1/1/1900' | ||||
| COMDLRAM | numeric(19,5) 0.00 | ||||
| CMPSERNM | tinyint 0 | ||||
| COMMNTID | char(15) '' | ||||
| BRKFLD1 | smallint 0 | ||||
| BRKFLD2 | smallint 0 | ||||
| BRKFLD3 | smallint 0 | ||||
| TRXSORCE | char(13) '' | ||||
| PRSTADCD | char(15) '' | ||||
| SHIPMTHD | char(15) '' | ||||
| ISLINEINTRA | tinyint 0 | ||||
| DEX_ROW_ID | int auto number (1,1) | ||||
Related Tables
Tables that share columns with IVC30102. Click "Join" to add to your query.