Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA05100
Product: Project Accounting (258)
Series:
Display Name: PA Project Billing Master File Group Display Name: PA Billing Transactions Open
Physical Name: PA05100
Technical Name: PA_Project_Billing_MSTR
Group Technical Name: PA Billing Transactions Open
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | PABILLTRXT  | PA Biller Trx Type | Integer | PA_DDL_Biller_Trx_Type | 0 | |
| 2 | PADocnumber20 | PA Document No. | String | STR17_LBAU | 17 | |
| 3 | PADOCDT | PA Document Date | Date | PA_Date | 8 | |
| 4 | DCSTATUS | Document Status | Integer | DDL_Doc_Status | 0 | |
| 5 | CUSTNMBR | Customer Number | String | STR15_RM_Customer_Number | 15 | |
Key to the RM Customer MSTR (RM00101).
Click to show/hideSELECT
['PA Project Billing Master File'].CUSTNMBR AS 'PA Project Billing Master File-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
PA05100 AS ['PA Project Billing Master File']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['PA Project Billing Master File'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR | ||||||
| 6 | PACONTNUMBER | PA Contract Number | String | STR10_LBAU | 10 | |
| 7 | PAPROJNUMBER | PA Project Number | String | STR15_LBAU | 15 | |
| 8 | PABillingAmount | PA Billing Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 9 | PARetainer_Fee_Amount | PA Retainer Fee Amount | Currency | PA_DLR17_RBS0_STR$ | 17 | |
| 10 | APPLDAMT | Applied Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 11 | CURTRXAM | Current Trx Amount | Currency | DLR17_RBS0_UTR$ | 17 | |