Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA02000
Product: Project Accounting (258)
Series:
Display Name: PA Billing Cycle MSTR
Physical Name: PA02000
Technical Name: PA_Billing_Cycle_MSTR
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | PABILLCYCLEID  | PA Billing Cycle ID | String | STR15_LBAU | 15 | |
| 2 | PABILLCYCLEDESC | PA Billing Cycle Description | String | STR40 | 40 | |
| 3 | PABilling_Frequency | PA Billing Frequency | Integer | PA_DDL_Billing_Frequency | 0 | |
| 4 | PABillingFreqDetail | PA Billing Frequency Detail | Integer | INT3_RZ0_U | 3 | |
| 5 | PA_Day1 | PA Day1 | Integer | PA_DDL_Day1 | 0 | |
| 6 | PA_Month_Number | PA Month Number | INT2_U0 | Integer | 2 | |
| 7 | PA_Month_Number_1 | PA Month Number[1] | Integer | INT2_U0 | 2 | |
| 8 | PA_Month_Number_2 | PA Month Number[2] | Integer | INT2_U0 | 2 | |
| 9 | PA_Day_Number_1 | PA Day Number[1] | Integer | INT2_U0 | 2 | |
| 10 | PA_Day_Number | PA Day Number | INT2_U0 | Integer | 2 | |
| 11 | PA_Day_Number_2 | PA Day Number[2] | Integer | INT2_U0 | 2 | |
| 12 | PA_Day2 | PA Day2 | Integer | PA_DDL_Day2 | 0 | |
| 13 | PADays_Interval | PA Days Interval | Integer | INT3_U0 | 3 | |
| 14 | PADDLDay | PA DDL Day | Integer | PA_DDL_Day | 0 | |
| 15 | PAPrior_Days_Before_Bi | PA Prior Days Before Billing | Integer | INT3_RZ0_U | 3 | |
| 16 | PAInclSrvFees | PA Include Service Fees | Boolean | PA_CB_Service_Fees | 0 | |
| 17 | PA_Include_Project_Fee | PA Include Project Fee | Boolean | PA_CB_Include_Project_Fee | 0 | |
| 18 | PA_Include_Retainer_Fee | PA Include Retainer Fee | Boolean | PA_CB_Include_Retainer_Fee | 0 | |
| 19 | PAtotcbts | PA Label Checkbox - TS | Boolean | CB | 0 | |
| 20 | PAtotcbEL | PA Label Checkbox - EL | Boolean | CB | 0 | |
| 21 | PAtotcbML | PA Label Checkbox - ML | Boolean | CB | 0 | |
| 22 | PAtotcbvi | PA Label Checkbox - VI | Boolean | CB | 0 | |
| 23 | PAtotcber | PA Label Checkbox - EE | Boolean | CB | 0 | |
| 24 | PAtotcbinv | PA Label Checkbox - INV | Boolean | CB | 0 | |
| 25 | PAtotcbfee | PA Label Checkbox - FEE | Boolean | CB | 0 | |
| 26 | PAefbillfmt | PA Default Billing Format | Integer | PA_DDL_Def_Billing_Format | 0 | |
| 27 | NOTEINDX | Note Index | Currency | DLR14 | 14 | |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['PA Billing Cycle MSTR'].NOTEINDX AS 'PA Billing Cycle MSTR-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
PA02000 AS ['PA Billing Cycle MSTR']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['PA Billing Cycle MSTR'].NOTEINDX = ['Record Notes Master'].NOTEINDX | ||||||