Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ASILOC06
Product: SmartList (1493)
Series:
Display Name: ASI_PM_Transaction_OPEN
Physical Name: ASILOC06
Technical Name: ASI_PM_Transaction_OPENSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 DOCTYPE 
Document Type Integer DDL_Document_Type 0 Click to show/hide Document Types
1 Invoice
2 Finance Charge
3 Miscellaneous Charges
4 Return
5 Credit Memo2 VCHRNMBR Voucher Number String STR20_LBAU 20 Partial key to the PM Key Master File (PM00400).
Click to show/hide
SELECT
['ASI_PM_Transaction_OPEN'].VCHRNMBR AS 'ASI_PM_Transaction_OPEN-Voucher Number'
,['PM Key Master File'].CNTRLNUM AS 'PM Key Master File-Control Number'
FROM
ASILOC06 AS ['ASI_PM_Transaction_OPEN']
INNER JOIN
PM00400 AS ['PM Key Master File']
ON
['ASI_PM_Transaction_OPEN'].VCHRNMBR = ['PM Key Master File'].CNTRLNUM
AND
['ASI_PM_Transaction_OPEN'].DOCTYPE = ['PM Key Master File'].DOCTYPE3 ASIUSERDEF1 ASI User Defined Key1 String STR50 50 4 ASIUSERDEF2 ASI User Defined Key2 String STR50 50 5 ASIUSERDEF3 ASI User Defined Key3 String STR50 50 6 ASIUSERDEF4 ASI User Defined Key4 String STR50 50