Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
PAVIDN | PA Vendor Invoice Document No. |
String | 18 | View | |
RCPTLNNM | Receipt Line Number |
Long Integer | 4 | View | |
TAXDTLID | Tax Detail ID |
String | 16 | View | |
ACTINDX | Account Index |
Long Integer | 4 | View | |
TAXAMNT | Tax Amount |
Currency | 10 | View | |
ORTAXAMT | Originating Tax Amount |
Currency | 10 | View | |
TAXPURCH | Taxable Purchases |
Currency | 10 | View | |
ORGTXPCH | Originating Taxable Purchases |
Currency | 10 | View | |
TOTPURCH | Total Purchases |
Currency | 10 | View | |
ORTOTPUR | Originating Total Purchases |
Currency | 10 | View | |
TRXSORCE | TRX Source |
String | 14 | View | |
POP_Tax_Note_ID_Array_1 | POP Tax Note ID Array[1] |
Currency | 10 | View | |
POP_Tax_Note_ID_Array_2 | POP Tax Note ID Array[2] |
Currency | 10 | View | |
PCTAXAMT | Purchases Tax Amount |
Currency | 10 | View | |
FRTTXAMT | Freight Tax Amount |
Currency | 10 | View | |
MSCTXAMT | Misc Tax Amount |
Currency | 10 | View | |
TXDTTPUR | Tax Detail Total Purchases |
Currency | 10 | View | |
TDTTXPUR | Tax Detail Total Taxable Purchases |
Currency | 10 | View | |
CURRNIDX | Currency Index |
Integer | 2 | View | |
BKOUTTAX | Backout Tax |
Boolean | 2 | View | |
ORPURTAX | Originating Purchases Tax Amount |
Currency | 10 | View | |
ORFRTTAX | Originating Freight Tax Amount |
Currency | 10 | View | |
ORMSCTAX | Originating Misc Tax Amount |
Currency | 10 | View | |
PAOTDTP | PA Originating Tax Detail Total Purchases |
Currency | 10 | View | |
PAOTDTT | PA Originating Tax Detail Total Taxable Purchases |
Currency | 10 | View |