PA Purchase Requisition History (PA30701)

azurecurveProductsProject Accounting (258)ProjectPA Purchase Requisition History (PA30701)

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

Product: Project Accounting (258)
Series:

Display Name: PA Purchase Requisition History
Physical Name: PA30701
Technical Name: PA_REQ_HIST

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1POPRequisitionNumber SearchPOP Requisition NumberStringSTR17_POP_Number17
2ORD SearchOrdLong IntegerLI_Sequence_Number10
3ITEMNMBR SearchItem NumberStringSTR30_Item_Number30
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['PA Purchase Requisition History'].ITEMNMBR AS 'PA Purchase Requisition History-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       PA30701 AS ['PA Purchase Requisition History']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['PA Purchase Requisition History'].ITEMNMBR = ['Item Master'].ITEMNMBR
4DATEVAL SearchDateValueDateDATE6
5FRTAMNT SearchFreight AmountCurrencyDLR17_RBS0_UTR$17
6ITMTSHID SearchItem Tax Schedule IDStringSTR15_LBAU15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

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

Click to show/hide

SELECT
       ['PA Purchase Requisition History'].UOMSCHDL AS 'PA Purchase Requisition History-U Of M Schedule'
       ,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
FROM
       PA30701 AS ['PA Purchase Requisition History']
INNER JOIN
       IV40201 AS ['Inventory U of M Schedule Setup']
              ON
                     ['PA Purchase Requisition History'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL
azurecurveProductsProject Accounting (258)ProjectPA Purchase Requisition History (PA30701)

Leave a Reply

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