PA30600 - PA Purchase Order History
Dynamics GP table PA30600 (PA Purchase Order History) contains 17 columns including PApurordnum, HOLD, HOLDREMOVEBY....
SQL Query Builder
17 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| PApurordnum | PA Purchase Order No. | String | 18 | ||
| HOLD | Hold | Boolean | 2 | ||
Hold Status values (2) 0 = Not on hold1 = On hold | |||||
| HOLDREMOVEBY | Hold Remove By | String | 16 | ||
| HOLDREMOVEDATE | Hold Remove Date | Date | 4 | ||
| NOTEINDX | Note Index | Currency | 10 | ||
| ONHOLDBY | On Hold By | String | 16 | ||
| ONHOLDDATE | On Hold Date | Date | 4 | ||
| ONORDAMT | On Order Amount | Currency | 10 | ||
| ORORDAMT | Originating On Order Amount | Currency | 10 | ||
| PApodeformatouse | PA Default Format to Use - PO | Integer | 2 | ||
| PAlastprtby | PA Last Printed By | String | 16 | ||
| PA_Trade_Discount_Pcnt | PA Trade Discount Percent | Integer | 2 | ||
| RegKey | RegKey | String | 130 | ||
| TRXTYPE | Transaction Type | Integer | 2 | ||
Transaction Type values (2) 0 = Standard1 = Reversing | |||||
| USEADVTX | Use Advanced Taxes | Integer | 2 | ||
| USERID | User ID | String | 16 | ||
| CMMTTEXT | Comment Text | Text | 2 | ||
Related Tables
Tables that share columns with PA30600. Click "Join" to add to your query.