PA10701 - PA PO Receipt Work
Dynamics GP table PA10701 (PA PO Receipt Work) contains 33 columns including PAVIDN, CARDNAME, CASHAMNT....
SQL Query Builder
33 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| PAVIDN | PA Vendor Invoice Document No. | String | 18 | ||
| CARDNAME | Card Name | String | 16 | ||
| CASHAMNT | Cash Amount | Currency | 10 | ||
| CAMCBKID | Cash Amount Checkbook ID | String | 16 | ||
| CAMTDATE | Cash Amount Date | Date | 4 | ||
| CAMPMTNM | Cash Amount Payment Number | String | 22 | ||
| CDOCNMBR | Cash Document Number | String | 22 | ||
| CHEKAMNT | Check Amount | Currency | 10 | ||
| CHAMCBID | Check Amount Checkbook ID | String | 16 | ||
| CAMPYNBR | Check Amount Payment Number | String | 22 | ||
| CHEKDATE | Check Date | Date | 4 | ||
| CHEKNMBR | Check Number | String | 22 | ||
| CRCRDAMT | Credit Card Amount | Currency | 10 | ||
| CCAMPYNM | Credit Card Amount Payment Number | String | 22 | ||
| CRCARDDT | Credit Card Date | Date | 4 | ||
| CCRCTNUM | Credit Card Receipt Number | String | 22 | ||
| DISTKNAM | Discount Taken Amount | Currency | 10 | ||
| NOTEINDX | Note Index | Currency | 10 | ||
| ORCASAMT | Originating Cash Amount | Currency | 10 | ||
| ORCHKAMT | Originating Check Amount | Currency | 10 | ||
| ORCCDAMT | Originating Credit Card Amount | Currency | 10 | ||
| ORDISTKN | Originating Discount Taken Amount | Currency | 10 | ||
| PACOMM | PA Comment | String | 52 | ||
| PAFreight_Taxable_P | PA Freight Taxable - Purchase | Integer | 2 | ||
| PAMisc_Taxable_P | PA Misc Taxable - Purchase | Integer | 2 | ||
| PAPO_HDR_Errors | PA PO HDR Errors | Long Integer | 4 | ||
| PAPO_Line_Errors | PA PO Line Errors | Long Integer | 4 | ||
| PApostoDynPM | PA Post to Dyn Payables Mgmt | Boolean | 2 | ||
| PA_Trade_Discount_Pcnt | PA Trade Discount Percent | Integer | 2 | ||
| PAUD1 | PA User Defined 1 | String | 22 | ||
| PAUD2 | PA User Defined 2 | String | 22 | ||
| TRXTYPE | Transaction Type | Integer | 2 | ||
Transaction Type values (2) 0 = Standard1 = Reversing | |||||
| USEADVTX | Use Advanced Taxes | Integer | 2 | ||
Related Tables
Tables that share columns with PA10701. Click "Join" to add to your query.