PO_Non_Stock_Items (PO10900)

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

Product: WennSoft Products (131)
Series: Purchasing

Display Name: PO_Non_Stock_Items
Physical Name: PO10900
Technical Name: PO_Non_Stock_Items

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1ITMNUM SearchItem_Number_STRSTR30_Item_NumberString30
2ITMDESC SearchItem_Description_STRSTR50String50
3QYORD SearchQuantity_Ordered_DOLDLR17_RBS0_STRCurrency17
4UOM SearchUnit_Of_Measure_STRU_Of_MString8
5UNITCOST SearchUnit CostDLR17_RBS0_UTR$Currency17
6ACTINDX SearchAccount IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['PO_Non_Stock_Items'].ACTINDX AS 'PO_Non_Stock_Items-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       PO10900 AS ['PO_Non_Stock_Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['PO_Non_Stock_Items'].ACTINDX = ['Account Index Master'].ACTINDX

Leave a Reply

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