PA Purchase Requisition (PA10603)

azurecurveProductsProject Accounting (258)ProjectPA Purchase Requisition (PA10603)

Easily find this page again using the shortlink:

Product: Project Accounting (258)
Series: Project

Display Name: PA Purchase Requisition
Physical Name: PA10603
Technical Name: PA_REQ_WORK

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1POPRequisitionNumber SearchPOP Requisition NumberSTR17_POP_NumberString17
2ORD SearchOrdLI_Sequence_NumberLong Integer10
3ITEMNMBR SearchItem NumberSTR30_Item_NumberString30
Key to the Item Master (IV00101).

Click to show/hide

       ['PA Purchase Requisition'].ITEMNMBR AS 'PA Purchase Requisition-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
       PA10603 AS ['PA Purchase Requisition']
       IV00101 AS ['Item Master']
                     ['PA Purchase Requisition'].ITEMNMBR = ['Item Master'].ITEMNMBR
4DATEVAL SearchDateValueDATEDate6
5FRTAMNT SearchFreight AmountDLR17_RBS0_UTR$Currency17
6ITMTSHID SearchItem Tax Schedule IDSTR15_LBAUString15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

       ['PA Purchase Requisition'].ITMTSHID AS 'PA Purchase Requisition-Item Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
       PA10603 AS ['PA Purchase Requisition']
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
                     ['PA Purchase Requisition'].ITMTSHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
7ORFRTAMT SearchOriginating Freight AmountDLR17_RBS0_UTR$Currency17
8PABase_Qty SearchPA Base QtyPA_DLR15_RBS0_STRCurrency15
9PABase_Unit_Cost SearchPA Base Unit CostPA_DLR17_RBS0_STR$Currency17
10PAbillnoteidx SearchPA Billing Note IndexDLR14Currency14
11PACBADDFRMFLY SearchPA CB From Add On The FlyCBBoolean0
12PACHGORDNO SearchPA Change Order NumberSTR17_LBAUString17
13PACogs_Idx SearchPA COGS IDXLI_14Long Integer14
14PACOSTCATID SearchPA Cost Category IDSTR15_Cost_Category_IDString15
15PAIV_Item_Checkbox SearchPA IV Item CheckboxPA_CB_IV_ItemBoolean0
16PALineItemSeq SearchPA Line Item SequenceLI_Sequence_NumberLong Integer10
17PAORGBSUNITCST SearchPA Originating Base Unit CostPA_DLR17_RBS0_STR$Currency17
18PAprojname SearchPA Project NameSTR30_PTBS Description 1String30
19PAPROJNUMBER SearchPA Project NumberSTR15_LBAUString15
20PAProjectType SearchPA Project TypePA_DDL_Project_TypeInteger0
21PAPurchase_Tax_Options SearchPA Purchase Tax OptionsPA_DDL_Tax_Options_PurchaseInteger0
22PATU SearchPA Transaction UsagePA_DDL_Transaction_UsageInteger0
23PACGBWIPIDX SearchPA WIP IDXLI_14Long Integer14
24PostedSubtotal SearchPosted SubtotalDLR17_RBS0_STR$Currency17
25PRICELVL SearchPrice LevelSTR15_LBAUString15
26UOMSCHDL SearchU Of M ScheduleSTR10_ScheduleString10
Key to the Inventory U of M Schedule Setup (IV40201).

Click to show/hide

       ['PA Purchase Requisition'].UOMSCHDL AS 'PA Purchase Requisition-U Of M Schedule'
       ,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
       PA10603 AS ['PA Purchase Requisition']
       IV40201 AS ['Inventory U of M Schedule Setup']
                     ['PA Purchase Requisition'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL
27DEX_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.

azurecurveProductsProject Accounting (258)ProjectPA Purchase Requisition (PA10603)

Leave a Reply

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