Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA01901
Product: Project Accounting (258)
Series:
Display Name: PA Key Master Group Display Name: PA Key Master
Physical Name: PA01901
Technical Name: PA_Key_MSTR
Group Technical Name: PA Key Master
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | PATranType  | PA Transaction Type | Integer | INT1 | 1 | |
| 2 | DOCNUMBR | Document Number | String | STR20_Document_Number | 20 | |
| 3 | CUSTNMBR | Customer Number | String | STR15_RM_Customer_Number | 15 | |
Key to the RM Customer MSTR (RM00101).
Click to show/hideSELECT
['PA Key Master'].CUSTNMBR AS 'PA Key Master-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
PA01901 AS ['PA Key Master']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['PA Key Master'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR | ||||||
| 4 | PADOCDT | PA Document Date | Date | PA_Date | 8 | |
| 5 | PACOSTOWNER | PA Cost Owner | String | STR30_Item_Number | 30 | |
| 6 | 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 | ||||||
| 7 | PABILLTRXT | PA Biller Trx Type | Integer | PA_DDL_Biller_Trx_Type | 0 | |
| 8 | PADocnumber20 | PA Document No. | String | STR17_LBAU | 17 | |
| 9 | DCSTATUS | Document Status | Integer | DDL_Doc_Status | 0 | |