| 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 | |
| IVDOCNBR | IV Document Number |
String | 18 | View | |
| PADOCDT | PA Document Date |
Date | 4 | View | |
| PAREFNO | PA Reference Document No. |
String | 18 | View | |
| VENDORID | Vendor ID |
String | 16 | View | |
| PAYR | PA Year |
Integer | 2 | 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 | |
| LOCNCODE | Location Code |
String | 12 | 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 | |
| PAIV_HDR_Errors | PA IV HDR Errors |
Long Integer | 4 | View | |
| PAIVDistributionErrors | PA IV Distribution Errors |
Long Integer | 4 | View | |
| LNITMSEQ | Line Item Sequence |
Long Integer | 4 | View | |
| NOTEINDX | Note Index |
Currency | 10 | View | |
| TAXSCHID | Tax Schedule ID |
String | 16 | View | |
| PAVENADDRESSID | PA Vendor Address ID |
String | 16 | View | |
| SHIPMTHD | Shipping Method |
String | 16 | View | |
| TAXAMNT | Tax Amount |
Currency | 10 | 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 |