PA30900 - PA Inventory Transfer History Header
Dynamics GP table PA30900 (PA Inventory Transfer History Header) contains 30 columns including PAIV_Document_No, PAIV_Transfer_Type, PADOCDT....
SQL Query Builder
30 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| PAIV_Document_No | PA IV Document No | String | 18 | ||
| PAIV_Transfer_Type | PA IV Transfer Type | Integer | 2 | ||
| PADOCDT | PA Document Date | Date | 4 | ||
| PAREFNO | PA Reference Document No. | String | 18 | ||
| VENDORID | Vendor ID | String | 16 | ||
| LOCNCODE | Location Code | String | 12 | ||
| 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 | ||
| 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 | ||
| IVDOCNBR | IV Document Number | String | 18 | ||
| VOIDSTTS | Void Status0 = Document has not been voided.1 = Document has been voided.2 = Document has been marked NSF and voided. | Integer | 2 | ||
Void Status values (2) 0 = Normal1 = Voided | |||||
| VOIDDATE | Void Date | Date | 4 | ||
| NOTEINDX | Note Index | Currency | 10 | ||
| TAXSCHID | Tax Schedule ID | String | 16 | ||
| TAXAMNT | Tax Amount | Currency | 10 | ||
| SHIPMTHD | Shipping Method | String | 16 | ||
| PAVENADDRESSID | PA Vendor Address ID | String | 16 | ||
| 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 PA30900. Click "Join" to add to your query.