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 TypeLength
1PApurordnum SearchPA Purchase Order No.STR17_LBAUString17
2ORD SearchOrdLI_Sequence_NumberLong Integer10
3BRKFLD1 SearchBreak Field 1INT1Integer1
4ITEMNMBR SearchItem NumberSTR30_Item_NumberString30
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_NumberString30
6DATEVAL SearchDateValueDATEDate6
7FRTAMNT SearchFreight AmountDLR17_RBS0_UTR$Currency17
8ITMTSHID SearchItem Tax Schedule IDSTR15_LBAUString15
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$Currency17
10ORFRTAMT SearchOriginating Freight AmountDLR17_RBS0_UTR$Currency17
11OMISCAMT SearchOriginating Misc Charges AmountDLR17_RBS0_UTR$Currency17
12ORTDISAM SearchOriginating Trade Discount AmountDLR17_RBS0_UTR$Currency17
13PABase_Qty SearchPA Base QtyPA_DLR15_RBS0_STRCurrency15
14PABase_Unit_Cost SearchPA Base Unit CostPA_DLR17_RBS0_STR$Currency17
15PAbillnoteidx SearchPA Billing Note IndexDLR14Currency14
16PACBADDFRMFLY SearchPA CB From Add On The FlyCBBoolean0
17PACHGORDNO SearchPA Change Order NumberSTR17_LBAUString17
18PACogs_Idx SearchPA COGS IDXLI_14Long Integer14
19PACOSTCATID SearchPA Cost Category IDSTR15_Cost_Category_IDString15
20PAIV_Item_Checkbox SearchPA IV Item CheckboxPA_CB_IV_ItemBoolean0
21PALineItemSeq SearchPA Line Item SequenceLI_Sequence_NumberLong Integer10
22PAORGBSUNITCST SearchPA Originating Base Unit CostPA_DLR17_RBS0_STR$Currency17
23PAprojname SearchPA Project NameSTR30_PTBS Description 1String30
24PAPROJNUMBER SearchPA Project NumberSTR15_LBAUString15
25PAProjectType SearchPA Project TypePA_DDL_Project_TypeInteger0
26PAPurchase_Tax_Options SearchPA Purchase Tax OptionsPA_DDL_Tax_Options_PurchaseInteger0
27PATU SearchPA Transaction UsagePA_DDL_Transaction_UsageInteger0
28PACGBWIPIDX SearchPA WIP IDXLI_14Long Integer14
29PostedSubtotal SearchPosted SubtotalDLR17_RBS0_STR$Currency17
30PRICELVL SearchPrice LevelSTR15_LBAUString15
31TRDISAMT SearchTrade Discount AmountDLR17_RBS0_UTR$Currency17
32UOMSCHDL SearchU Of M ScheduleSTR10_ScheduleString10
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 Searchintint10

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 *