PA Purchase Order Line (PA10601)

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

Product: Project Accounting (258)
Series: Project

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 TypeSQL DB LengthKeyable Length
1PApurordnum SearchPA Purchase Order No.STR17_LBAUString1817
2ORD SearchOrdLI_Sequence_NumberLong Integer410
3BRKFLD1 SearchBreak Field 1INT1Integer21
4ITEMNMBR SearchItem NumberSTR30_Item_NumberString3230
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 NumberItem_NumberString3230
6DATEVAL SearchDateValueDATEDate46
7FRTAMNT SearchFreight AmountDLR17_RBS0_UTR$Currency1017
8ITMTSHID SearchItem Tax Schedule IDSTR15_LBAUString1615
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 AmountDLR17_RBS0_UTR$Currency1017
10ORFRTAMT SearchOriginating Freight AmountDLR17_RBS0_UTR$Currency1017
11OMISCAMT SearchOriginating Misc Charges AmountDLR17_RBS0_UTR$Currency1017
12ORTDISAM SearchOriginating Trade Discount AmountDLR17_RBS0_UTR$Currency1017
13PABase_Qty SearchPA Base QtyPA_DLR15_RBS0_STRCurrency1015
14PABase_Unit_Cost SearchPA Base Unit CostPA_DLR17_RBS0_STR$Currency1017
15PAbillnoteidx SearchPA Billing Note IndexDLR14Currency1014
16PACBADDFRMFLY SearchPA CB From Add On The FlyCBBoolean20
17PACHGORDNO SearchPA Change Order NumberSTR17_LBAUString1817
18PACogs_Idx SearchPA COGS IDXLI_14Long Integer414
19PACOSTCATID SearchPA Cost Category IDSTR15_Cost_Category_IDString1615
20PAIV_Item_Checkbox SearchPA IV Item CheckboxPA_CB_IV_ItemBoolean20
21PALineItemSeq SearchPA Line Item SequenceLI_Sequence_NumberLong Integer410
22PAORGBSUNITCST SearchPA Originating Base Unit CostPA_DLR17_RBS0_STR$Currency1017
23PAprojname SearchPA Project NameSTR30_PTBS Description 1String3230
24PAPROJNUMBER SearchPA Project NumberSTR15_LBAUString1615
25PAProjectType SearchPA Project TypePA_DDL_Project_TypeInteger20
26PAPurchase_Tax_Options SearchPA Purchase Tax OptionsPA_DDL_Tax_Options_PurchaseInteger20
27PATU SearchPA Transaction UsagePA_DDL_Transaction_UsageInteger20
28PACGBWIPIDX SearchPA WIP IDXLI_14Long Integer414
29PostedSubtotal SearchPosted SubtotalDLR17_RBS0_STR$Currency1017
30PRICELVL SearchPrice LevelSTR15_LBAUString1615
31TRDISAMT SearchTrade Discount AmountDLR17_RBS0_UTR$Currency1017
32UOMSCHDL SearchU Of M ScheduleSTR10_ScheduleString1210
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
33DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

Leave a Reply

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