PA10900 - PA Inventory Transfer Work Header
Dynamics GP table PA10900 (PA Inventory Transfer Work Header) contains 32 columns including PAIV_Document_No, PAIV_Transfer_Type, IVDOCNBR....
SQL Query Builder
32 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| PAIV_Document_No | PA IV Document No | String | 18 | |
| PAIV_Transfer_Type | PA IV Transfer Type | Integer | 2 | |
| IVDOCNBR | IV Document Number | String | 18 | |
| PADOCDT | PA Document Date | Date | 4 | |
| PAREFNO | PA Reference Document No. | String | 18 | |
| VENDORID | Vendor ID | String | 16 | |
| PAYR | PA Year | Integer | 2 | |
| PAPD | PA Post Date | Date | 4 | |
| USERID | User ID | String | 16 | |
| BACHNUMB | Batch Number | String | 16 | |
| BCHSOURC | Batch Source | String | 16 | |
| TRXSORCE | TRX Source | String | 14 | |
| LOCNCODE | Location Code | String | 12 | |
| PACOMM | PA Comment | String | 52 | |
| REQSTDBY | Requested By | String | 22 | |
| PATQTY | PA Total Quantity | Currency | 10 | |
| PAtotcosts | PA Total Costs | Currency | 10 | |
| PATACRV | PA Total Accrued Revenues | Currency | 10 | |
| PAUD1 | PA User Defined 1 | String | 22 | |
| PAUD2 | PA User Defined 2 | String | 22 | |
| PAIV_HDR_Errors | PA IV HDR Errors | Long Integer | 4 | |
| PAIVDistributionErrors | PA IV Distribution Errors | Long Integer | 4 | |
| LNITMSEQ | Line Item Sequence | Long Integer | 4 | |
| NOTEINDX | Note Index | Currency | 10 | |
| TAXSCHID | Tax Schedule ID | String | 16 | |
| PAVENADDRESSID | PA Vendor Address ID | String | 16 | |
| SHIPMTHD | Shipping Method | String | 16 | |
| TAXAMNT | Tax Amount | Currency | 10 | |
| BKTPURAM | Backout Purchases Amount | Currency | 10 | |
| Tax_Date | Tax Date | Date | 4 | |
| TaxInvRecvd | Tax Invoice Received | Boolean | 2 | |
| TaxInvReqd | Tax Invoice Required | Boolean | 2 |
Related Tables
Tables that share columns with PA10900. Click "Join" to add to your query.