Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/FA01000
Product: Fixed Assets (309)
Series:
Display Name: FA Audit Trail Codes Group Display Name: Fixed Assets Master
Physical Name: FA01000
Technical Name: FA_Transaction_Source_MSTR
Group Technical Name: Fixed Assets Master
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | REPRNTNT  | Reprint NT | Boolean | CB | 0 | |
| 2 | SERIES | Series | Integer | DDL_Series | 0 | |
| 3 | SEQNUMBR | Sequence Number | Long Integer | LI_Sequence_Number | 10 | |
| 4 | TRXSOURC | Transaction Source | String | STR25 | 25 | |
| 5 | TRXSRCPX | Transaction Source Prefix | String | Transaction Source Prefix | 5 | |
| 6 | NTRXSNUM | Next Transaction Source Number | Long Integer | LI_8_POS | 8 | |
| 7 | SOURCDOC | Source Document | String | STR10_Source_Document | 10 | |
Key to the Source Document Master (SY00900).
Click to show/hideSELECT
['FA Audit Trail Codes'].SOURCDOC AS 'FA Audit Trail Codes-Source Document'
,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
FA01000 AS ['FA Audit Trail Codes']
INNER JOIN
SY00900 AS ['Source Document Master']
ON
['FA Audit Trail Codes'].SOURCDOC = ['Source Document Master'].SOURCDOC | ||||||