GST00105 - PA Purchasing Tax History
Dynamics GP table GST00105 (PA Purchasing Tax History) contains 25 columns including PAVIDN, RCPTLNNM, TAXDTLID....
SQL Query Builder
25 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| PAVIDN | PA Vendor Invoice Document No. | String | 18 | |
| RCPTLNNM | Receipt Line Number | Long Integer | 4 | |
| TAXDTLID | Tax Detail ID | String | 16 | |
| ACTINDX | Account Index Links to GL00105 to get the full concatenated account number and description. This is the primary key for account lookups across all modules. | Long Integer | 4 | |
| TAXAMNT | Tax Amount | Currency | 10 | |
| ORTAXAMT | Originating Tax Amount | Currency | 10 | |
| TAXPURCH | Taxable Purchases | Currency | 10 | |
| ORGTXPCH | Originating Taxable Purchases | Currency | 10 | |
| TOTPURCH | Total Purchases | Currency | 10 | |
| ORTOTPUR | Originating Total Purchases | Currency | 10 | |
| TRXSORCE | TRX Source | String | 14 | |
| POP_Tax_Note_ID_Array_1 | POP Tax Note ID Array[1] | Currency | 10 | |
| POP_Tax_Note_ID_Array_2 | POP Tax Note ID Array[2] | Currency | 10 | |
| PCTAXAMT | Purchases Tax Amount | Currency | 10 | |
| FRTTXAMT | Freight Tax Amount | Currency | 10 | |
| MSCTXAMT | Misc Tax Amount | Currency | 10 | |
| TXDTTPUR | Tax Detail Total Purchases | Currency | 10 | |
| TDTTXPUR | Tax Detail Total Taxable Purchases | Currency | 10 | |
| CURRNIDX | Currency Index | Integer | 2 | |
| BKOUTTAX | Backout Tax | Boolean | 2 | |
| ORPURTAX | Originating Purchases Tax Amount | Currency | 10 | |
| ORFRTTAX | Originating Freight Tax Amount | Currency | 10 | |
| ORMSCTAX | Originating Misc Tax Amount | Currency | 10 | |
| PAOTDTP | PA Originating Tax Detail Total Purchases | Currency | 10 | |
| PAOTDTT | PA Originating Tax Detail Total Taxable Purchases | Currency | 10 |
Related Tables
Tables that share columns with GST00105. Click "Join" to add to your query.