ASI_PM_Transaction_OPEN (ASILOC06)

azurecurveProductsSmartList (1493)PurchasingASI_PM_Transaction_OPEN (ASILOC06)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ASILOC06

Product: SmartList (1493)
Series: Purchasing

Display Name: ASI_PM_Transaction_OPEN
Physical Name: ASILOC06
Technical Name: ASI_PM_Transaction_OPEN

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1DOCTYPE SearchDocument TypeDDL_Document_TypeInteger0

Click to show/hide Document Types


1	Invoice
2	Finance Charge
3	Miscellaneous Charges
4	Return
5	Credit Memo
2VCHRNMBR SearchVoucher NumberSTR20_LBAUString20
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'].DOCTYPE
3ASIUSERDEF1 SearchASI User Defined Key1STR50String50
4ASIUSERDEF2 SearchASI User Defined Key2STR50String50
5ASIUSERDEF3 SearchASI User Defined Key3STR50String50
6ASIUSERDEF4 SearchASI User Defined Key4STR50String50
azurecurveProductsSmartList (1493)PurchasingASI_PM_Transaction_OPEN (ASILOC06)

Leave a Reply

Your email address will not be published. Required fields are marked *