PA Purchase Order Line (PA10601)

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

Product: Project Accounting (258)
Series:

Display Name: PA Purchase Order Line
Physical Name: PA10601
Technical Name: PA_PO_WORK_LINE

Group Display Name: PA Purchasing Transactions
Group Technical Name: PA Purchasing Transactions

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PApurordnum SearchPA Purchase Order No.StringSTR17_LBAU17
2ORD SearchOrdLong IntegerLI_Sequence_Number10
3BRKFLD1 SearchBreak Field 1IntegerINT11
4ITEMNMBR SearchItem NumberStringSTR30_Item_Number30
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['PA Purchase Order Line'].ITEMNMBR AS 'PA Purchase Order Line-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       PA10601 AS ['PA Purchase Order Line']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['PA Purchase Order Line'].ITEMNMBR = ['Item Master'].ITEMNMBR
5VNDITNUM SearchVendor Item NumberStringItem_Number30
6DATEVAL SearchDateValueDateDATE6
7FRTAMNT SearchFreight AmountCurrencyDLR17_RBS0_UTR$17
8ITMTSHID SearchItem Tax Schedule IDStringSTR15_LBAU15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['PA Purchase Order Line'].ITMTSHID AS 'PA Purchase Order Line-Item Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       PA10601 AS ['PA Purchase Order Line']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['PA Purchase Order Line'].ITMTSHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
9MSCCHAMT SearchMisc Charges AmountCurrencyDLR17_RBS0_UTR$17
10ORFRTAMT SearchOriginating Freight AmountCurrencyDLR17_RBS0_UTR$17
11OMISCAMT SearchOriginating Misc Charges AmountCurrencyDLR17_RBS0_UTR$17
12ORTDISAM SearchOriginating Trade Discount AmountCurrencyDLR17_RBS0_UTR$17
13PABase_Qty SearchPA Base QtyCurrencyPA_DLR15_RBS0_STR15
14PABase_Unit_Cost SearchPA Base Unit CostCurrencyPA_DLR17_RBS0_STR$17
15PAbillnoteidx SearchPA Billing Note IndexCurrencyDLR1414
16PACBADDFRMFLY SearchPA CB From Add On The FlyBooleanCB0
17PACHGORDNO SearchPA Change Order NumberStringSTR17_LBAU17
18PACogs_Idx SearchPA COGS IDXLong IntegerLI_1414
19PACOSTCATID SearchPA Cost Category IDStringSTR15_Cost_Category_ID15
20PAIV_Item_Checkbox SearchPA IV Item CheckboxBooleanPA_CB_IV_Item0
21PALineItemSeq SearchPA Line Item SequenceLong IntegerLI_Sequence_Number10
22PAORGBSUNITCST SearchPA Originating Base Unit CostCurrencyPA_DLR17_RBS0_STR$17
23PAprojname SearchPA Project NameStringSTR30_PTBS Description 130
24PAPROJNUMBER SearchPA Project NumberStringSTR15_LBAU15
25PAProjectType SearchPA Project TypeIntegerPA_DDL_Project_Type0
26PAPurchase_Tax_Options SearchPA Purchase Tax OptionsIntegerPA_DDL_Tax_Options_Purchase0
27PATU SearchPA Transaction UsageIntegerPA_DDL_Transaction_Usage0
28PACGBWIPIDX SearchPA WIP IDXLong IntegerLI_1414
29PostedSubtotal SearchPosted SubtotalCurrencyDLR17_RBS0_STR$17
30PRICELVL SearchPrice LevelStringSTR15_LBAU15
31TRDISAMT SearchTrade Discount AmountCurrencyDLR17_RBS0_UTR$17
32UOMSCHDL SearchU Of M ScheduleStringSTR10_Schedule10
Key to the Inventory U of M Schedule Setup (IV40201).

Click to show/hide

SELECT
       ['PA Purchase Order Line'].UOMSCHDL AS 'PA Purchase Order Line-U Of M Schedule'
       ,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
FROM
       PA10601 AS ['PA Purchase Order Line']
INNER JOIN
       IV40201 AS ['Inventory U of M Schedule Setup']
              ON
                     ['PA Purchase Order Line'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL

Leave a Reply

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