Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SY01000
Product: Microsoft Dynamics GP (0)
Series: Company
Display Name: Audit Trail Codes Group Display Name: Audit Trail Codes
Physical Name: SY01000
Technical Name: SY_Transaction_Source_MSTR
Group Technical Name: Audit Trail Codes
| 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
['Audit Trail Codes'].SOURCDOC AS 'Audit Trail Codes-Source Document'
,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
SY01000 AS ['Audit Trail Codes']
INNER JOIN
SY00900 AS ['Source Document Master']
ON
['Audit Trail Codes'].SOURCDOC = ['Source Document Master'].SOURCDOC | ||||||