PA00401 - PA Fee Master File
Dynamics GP table PA00401 (PA Fee Master File) contains 26 columns including PAFeeID, PAFeeName, PAFeeType....
SQL Query Builder
26 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| PAFeeID | PA Fee ID | String | 16 | |
| PAFeeName | PA Fee Name | String | 32 | |
| PAFeeType | PA Fee Type | Integer | 2 | |
| PAFrequency | PA Frequency | Integer | 2 | |
| PAPercent_Cost | PA Percent Cost | Currency | 10 | |
| PAPercent_Revenue | PA Percent Revenue | Currency | 10 | |
| PA_Retention_Percent | PA Retention Percent | Currency | 10 | |
| PAFeeToUse | PA Fee To Use | Integer | 2 | |
| PAFeeAmount | PA Fee Amount | Currency | 10 | |
| PASales_Tax_Options | PA Sales Tax Options | Integer | 2 | |
| PAbilltaxscheduleid | PA Billing Tax Schedule ID | String | 16 | |
| PAtotcbts | PA Label Checkbox - TS | Boolean | 2 | |
| PAtotcbEL | PA Label Checkbox - EL | Boolean | 2 | |
| PAtotcbML | PA Label Checkbox - ML | Boolean | 2 | |
| PAtotcbvi | PA Label Checkbox - VI | Boolean | 2 | |
| PAtotcber | PA Label Checkbox - EE | Boolean | 2 | |
| PAtotcbinv | PA Label Checkbox - INV | Boolean | 2 | |
| STRTDATE | Start Date | Date | 4 | |
| ENDDATE | End Date | Date | 4 | |
| PARenew | PA Renew | Boolean | 2 | |
| PARenewal_Date | PA Renewal Date | Date | 4 | |
| PANOTEINDEX | PA Note Index | Currency | 10 | |
| PA_Renew_Day | PA Renew Day | Integer | 2 | |
| PA_Renew_Month | PA Renew Month | Integer | 2 | |
| PAUD1 | PA User Defined 1 | String | 22 | |
| PAUD2 | PA User Defined 2 | String | 22 |
Related Tables
Tables that share columns with PA00401. Click "Join" to add to your query.