Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA23000
Product: Project Accounting (258)
Series:
Display Name: PA Applied OPEN Group Display Name: PA Billing Transactions Open
Physical Name: PA23000
Technical Name: PA_Applied_OPEN
Group Technical Name: PA Billing Transactions Open
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | DOCNUMBR  | Document Number | String | STR20_Document_Number | 20 | |
| 2 | RMDTYPAL | RM Document Type-All | Integer | INT2 | 2 | |
Document Type records the type of document.
Click to show/hide the Document Types
0 Balance Carried Forward
1 Sales / Invoice
2 Scheduled Payments
3 Debit Memo
4 Finance Charge
5 Service Repairs
6 Warranties
7 Credit Memo
8 Returns
9 Payments | ||||||
| 3 | PADocnumber20 | PA Document No. | String | STR17_LBAU | 17 | |
| 4 | CUSTNMBR | Customer Number | String | STR15_RM_Customer_Number | 15 | |
Key to the RM Customer MSTR (RM00101).
Click to show/hideSELECT
['PA Applied OPEN'].CUSTNMBR AS 'PA Applied OPEN-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
PA23000 AS ['PA Applied OPEN']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['PA Applied OPEN'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR | ||||||
| 5 | PABILLTRXT | PA Biller Trx Type | Integer | PA_DDL_Biller_Trx_Type | 0 | |
| 6 | PAPROJNUMBER | PA Project Number | String | STR15_LBAU | 15 | |
| 7 | PACCAA | PA CostCat Applied Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 8 | PAFAA | PA Fee Applied Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 9 | PATTA | PA Terms Taken Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 10 | PAWA | PA Writeoff Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 11 | PA_Tax_Applied_Amount | PA Tax Applied Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 12 | DOCDATE | Document Date | Date | DT | 8 | |
| 13 | TRXDSCRN | Transaction Description | String | STR30 | 30 | |