Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA33401
Product: Project Accounting (258)
Series:
Display Name: PA Billing Apply Distribution History Group Display Name: PA Billing Transactions History
Physical Name: PA33401
Technical Name: PA_Apply_Distribution_HIST
Group Technical Name: PA Billing Transactions History
| 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 | DOCNUMBR | Document Number | String | STR20_Document_Number | 20 | |
| 3 | PADocnumber20 | PA Document No. | String | STR17_LBAU | 17 | |
| 4 | PAPROJNUMBER | PA Project Number | String | STR15_LBAU | 15 | |
| 5 | PACOSTCATID | PA Cost Category ID | String | STR15_Cost_Category_ID | 15 | |
| 6 | SEQNUMBR | Sequence Number | Long Integer | LI_Sequence_Number | 10 | |
| 7 | DSTINDX | Distribution Account Index | Long Integer | LI_14 | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['PA Billing Apply Distribution History'].DSTINDX AS 'PA Billing Apply Distribution History-Distribution Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
PA33401 AS ['PA Billing Apply Distribution History']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['PA Billing Apply Distribution History'].DSTINDX = ['Account Index Master'].ACTINDX | ||||||
| 8 | PADISTAM | PA Distribution Amount | Currency | DLR19_$S2 | 19 | |
| 9 | PAREMAMO | PA Remaining Distribution Amount | Currency | DLR19_$S2 | 19 | |