Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
PAIV_Document_No | PA IV Document No |
String | 18 | View | |
PAIV_Transfer_Type | PA IV Transfer Type |
Integer | 2 | View | |
PADOCDT | PA Document Date |
Date | 4 | View | |
PAREFNO | PA Reference Document No. |
String | 18 | View | |
VENDORID | Vendor ID |
String | 16 | View | |
LOCNCODE | Location Code |
String | 12 | View | |
PAPD | PA Post Date |
Date | 4 | View | |
USERID | User ID |
String | 16 | View | |
BACHNUMB | Batch Number |
String | 16 | View | |
BCHSOURC | Batch Source |
String | 16 | View | |
TRXSORCE | TRX Source |
String | 14 | View | |
PACOMM | PA Comment |
String | 52 | View | |
REQSTDBY | Requested By |
String | 22 | View | |
PATQTY | PA Total Quantity |
Currency | 10 | View | |
PAtotcosts | PA Total Costs |
Currency | 10 | View | |
PATACRV | PA Total Accrued Revenues |
Currency | 10 | View | |
PAUD1 | PA User Defined 1 |
String | 22 | View | |
PAUD2 | PA User Defined 2 |
String | 22 | View | |
IVDOCNBR | IV Document Number |
String | 18 | View | |
VOIDSTTS | Void Status 0 = Document has not been voided. |
Integer | 2 | View | |
VOIDDATE | Void Date |
Date | 4 | View | |
NOTEINDX | Note Index |
Currency | 10 | View | |
TAXSCHID | Tax Schedule ID |
String | 16 | View | |
TAXAMNT | Tax Amount |
Currency | 10 | View | |
SHIPMTHD | Shipping Method |
String | 16 | View | |
PAVENADDRESSID | PA Vendor Address ID |
String | 16 | View | |
BKTPURAM | Backout Purchases Amount |
Currency | 10 | View | |
Tax_Date | Tax Date |
Date | 4 | View | |
TaxInvRecvd | Tax Invoice Received |
Boolean | 2 | View | |
TaxInvReqd | Tax Invoice Required |
Boolean | 2 | View |