pref_pop_sys (POPS0132)

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

Product: Manufacturing (346)
Series:

Display Name: pref_pop_sys
Physical Name: POPS0132
Technical Name: pref_pop_sys

Group Display Name: Manufacturing POP
Group Technical Name: Manufacturing POP

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1CMPANYID SearchCompany IDIntegerINT54
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['pref_pop_sys'].CMPANYID AS 'pref_pop_sys-Company ID'
       ,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
       POPS0132 AS ['pref_pop_sys']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['pref_pop_sys'].CMPANYID = ['Company Master'].CMPANYID
2PORDNMBR SearchPurchase Order NumberStringPurchase Order Number20
3POGENERATE_I SearchPO GenerateBooleanPO_CB_Generate0
4DDL_Order_Status SearchDDL_Order_StatusIntegerDDL_Order_Status0
5LOCNCODE SearchLocation CodeStringSTR10_Location_Code10
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['pref_pop_sys'].LOCNCODE AS 'pref_pop_sys-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       POPS0132 AS ['pref_pop_sys']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['pref_pop_sys'].LOCNCODE = ['Site Setup'].LOCNCODE
6POFOB_I SearchPO FOBStringSTR1515
7POFORCECROSSREF_I SearchPO Force Cross ReferenceBooleanCB0
8POTAXEXEMPT_I SearchPO Tax ExemptBooleanCB0
9NON_INV_CRED_ACCT_IDX_I SearchNon Inventory Credit Account IndexLong IntegerLI_1414
10NON_INV_DEB_ACCT_IDX_I SearchNon Inventory Debit Account IndexLong IntegerLI_1414

Leave a Reply

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