Purchasing Document Header Details
The Purchasing Document Header Details view object contains information about purchase order and purchase agreement headers.
Data Store Key : FscmTopModelAM.PrcExtractAM.PoBiccExtractAM.PurchasingDocumentHeaderExtractPVO
Primary Keys : PoHeaderId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
Name | Description |
---|---|
AcceptanceDueDate | Date that the supplier must accept the purchase order. |
AcceptanceRequiredFlag | Indicates whether acceptance from the supplier is required. |
AcceptanceWithinDays | Value that stores acknowledge within days. |
AgentId | Value that uniquely identifies the buyer. |
AgingOnsetPoint | Indicates the mutually agreed event point at which, consigned material begins to age. The possible values are None, Receipt, and Shipment. Applicable only to BPA. |
AgingPeriodDays | Indicates the maximum number of days the material may be on consignment. It defaults a value for the same term on the document line. Only positive values are allowed. Applicable only to BPA. |
AllowItemDescUpdateFlag | Value that indicates whether item descriptions can be updated on document lines. |
AllowManulPriceUpdateOrder | Indicates if the price can be manually updated on fulfilled purchase orders. |
AllowMultipleSitesFlag | Indicates whether an agreement can be used across all supplier sites for a given supplier. |
AllowRetroPricing | Indicates whether retroactive pricing may be used. |
AmountLimit | Value that identifies the maximum amount that can be released. Applicable only to Blanket, Contract, and Planned PO. |
AmountReleased | Value that identifies the amount released against this agreement. It's the sum of all the approved standard PO amounts. |
ApprovedDate | Date when the purchase order was last approved. |
ApprovedFlag | Indicates whether the purchase order is approved or not. If value is Y, the purchase order is approved. |
AwardApprovalEnabledFlag | Indicates whether to enable approval of award decision before it's completed. Possible values are Y or N. |
BccEmailAddress | Value that uniquely identifies the email address to which a copy of the email is sent without letting other recipients know. |
BillToLocationId | Value that uniquely identifies the bill-to location. |
BillingCycleClosingDate | Date when the current billing period for an agreement ends. This is applicable only for a BPA with consignment terms enabled. |
BilltoBuId | Value that uniquely identifies the business unit that processes supplier invoices for the purchase order. |
BlanketTotalAmount | Value that identifies the amount agreed to for the planned or blanket purchase order. |
BudgetControlEnabledFlag | Indicates whether budgetary control was enabled at the time of purchase order creation. Not applicable to agreements. |
BuyerManagedTransportFlag | Indicates whether the buying company is responsible for arranging the transportation From picking up the requested goods, to delivering to ship-to locations specified on the order. |
BypassApprovalFlag | Indicates whether the approval process needs to be bypassed on submission. |
CarrierId | Value that uniquely identifies the company that transports the item. |
CatAdminAuthEnabledFlag | Indicates that the BPA is enabled for catalog authoring. |
CatAdminAuthoringAcceptance | Acceptance level of Catalog Administrator for agreement change. |
CcEmailAddress | Value that uniquely identifies the email address to which a copy of the email is sent. |
ChangeRequestedBy | User who requested change to the purchase document. |
ChangeSummary | Description of changes made. This information is entered by the Buyer when submitting the document for approval and may be used in generating an amendment document. |
ClosedDate | Date the document was closed. |
Comments | Descriptive comments for the document. |
ConfirmingOrderFlag | Indicates whether the purchase order is a confirming order. |
ConsumptionAdviceFrequency | Value that identifies the default value of the frequency at which the Create Consumption Advice program will be run for all consumption transactions for consigned inventory purchased under this agreement. It defaults a value for the same term on the document line. The possible values are Daily, Weekly, and Monthly. Applicable only to BPA. |
ConsumptionAdviceSummary | Value that identifies the granularity at which consumption advices will be generated. The possible values are Inventory Organization, Item and Transaction Date, Inventory Organization and Item, Inventory Organization, and All Inventory Organizations. Applicable only to BPA. |
ContermsExistFlag | Value that identifies if a contract terms template is attached to the purchasing document. Applicable to Purchasing document of type Standard, Contract, and Blanket. |
CpaReference | CPA reference to support the iP catalog upgrade for items that had a CPA reference prior to Release 12. This column is just for information purpose. |
CreatedBy | User who created the purchasing document header details. |
CreatedLanguage | Language code in which the GBPA was created. |
CreationDate | Date and time when the purchasing document header details was created. |
CurrencyCode | Code that identifies the purchase order currency. |
CurrencyCode1 | Code that identifies the purchase order currency. |
DefaultBuyerId | Value that uniquely identifies the default buyer. |
DefaultConsignmentLineFlag | Indicates the default value for the Consignment line attribute on the agreement line. Values: Y or N. Applicable only to BPA. |
DefaultPoTradeOrgId | Value that uniquely identifies the purchasing trade organization. The purchasing trade organization is the inventory organization reporting to the sold-to legal entity identified in a purchase order. This organization is used for cost accounting the transactions in the sold-to legal entity. |
DefaultPromiseDate | Date that indicates the default promise date from need-by date. |
DefaultRateType | Default currency rate type for the purchasing document header details. |
DefaultTaxationCountry | Default country for taxation for tax calculation purposes. |
DoctypeId | Unique identifier for the document type. |
DocumentCreationMethod | Method in which the document got created such as Autocreate and enter PO. |
DocumentStatus | Value that identifies the header status. |
EmailAddress | Value that identifies the email address of the supplier for communication. |
EmailAttachmentFilename | Value that identifies the file name attached to the communication email sent to the supplier. |
EnabledFlag | Indicates whether the key Flexfield enabled is enabled or not. Possible values are Y or N. |
EncumbranceRequiredFlag | Indicates whether the document is to be encumbered or not. Possible values are Yes or No. |
EndDate | Value that identifies the expiration date of the document. |
EnforceMinBidPrice | Check box that indicates whether to enforce supplier's previous round price as start price. Used by Sourcing. |
EnforceVendorHoldFlag | Indicates whether you enforce supplier holds during purchase order approval. |
Fax | Value that identifies the supplier fax number. |
FirmDate | Date from which the purchase order is firmed. |
FirstPtyRegId | First Party Tax Registration ID for the transaction. |
FobLookupCode | Code that identifies the type of free-on-board terms for the document. |
FreightTermsLookupCode | Code that identifies the type of freight terms for the document |
FrozenFlag | Indicates whether the document is frozen. |
FundsStatus | Status to indicate whether funds have been reserved on the document or not. |
GenOrderForNegReqsFlag | Check box that indicates whether negotiated requisition lines having valid supplier information should be automatically processed to purchase orders even without any purchase agreement reference. |
GenerateOrdersAutomatic | Indicates whether order generation should trigger automatically. |
GroupRequisitionLines | Indicates whether requisition lines should be grouped together. |
GroupRequisitions | Indicates whether requisitions should be grouped together. |
InterfaceSourceCode | Value that identifies the upstream integrating module. Reserved for internal use. |
InventoryOrganizationId | Value that uniquely identifies the default inventory organization for the procurement business unit. |
InvoiceCloseTolerance | Default invoice close tolerance percent for business unit. |
LanguageCode | Value that identifies the default user language for the procurement business unit. |
LastBilledDate | Date when the consumption transaction on the agreement was last billed. |
LastReleaseDate | Date when the purchase order was last implemented against the agreement. |
LastUpdateDate | Date and time when the purchasing document was last updated |
LastUpdatedBy | User who last updated the document header. |
LineTypeId | Value that uniquely identifies the line type on your documents. |
ManualReceiptNumType | Receipt number type for manual generation. Possible values are Alphanumeric or Numeric. |
MasterContractId | Value that identifies the master contract identifier. The master contract refers to the general contract that primarily serves to set the terms and conditions between parties at a high level that govern subsequent, more specifically, contractual agreements. |
MatchOption | Indicator of whether the invoice for the shipment should be matched to the purchase order or the receipt. |
MaxAttachmentSize | Maximum allowed size of ZIP attachment file for the purchasing document header details. |
MinReleaseAmount | Value that identifies the minimum amount that can be released against a blanket or planned purchase order. |
ModeOfTransport | Mode of transport that the shipper uses to transport the item such as land, sea, and air. |
ModeOfTransport1 | Mode of transport that the shipper uses to transport the item such as land, sea, and air. |
NegApprovalEnabledFlag | Indicates whether to enable approval of a negotiation before the purchasing document is published. |
NoteToAuthorizer | Value that uniquely identifies a note to approver. |
NoteToReceiver | Value that uniquely identifies a note to receiver. |
NoteToVendor | Value that uniquely identifies a note to supplier. |
ObjectVersionNumber | Number of times the purchasing document has been updated. |
OrchestrationOrderFlag | Indicates whether the purchase order is an orchestrated purchase order. Valid values are Y or N. If Y, then the PO is an orchestrated order. If N, then the PO isn't an orchestrated order. |
OverridingApproverId | Value that uniquely identifies the user specified on the purchase order as the overriding approver for approval routing. |
PayOnCode | Code that identifies whether the purchase order will be paid upon receipt. |
PayOnUseFlag | Indicates whether self-billing is enabled for consumption of consigned material. Values: Y or N. Applicable only to BPA. |
PcardId | Value that uniquely identifies the procurement card used for the order. |
PendingSignatureFlag | Check box that indicates whether the purchasing document is pending signatures or not. Applicable to Purchasing document of type Standard, Contract, and Blanket. |
PoHeaderId | Value that uniquely identifies the purchase order. |
PrcBuId | Value that uniquely identifies the business unit that manages and owns the purchase order. |
PriceBreakLookupCode | Code that indicates the default price break type for catalog quotations and blanket agreements. |
PriceChangeAmount | Price difference in amount you allow between requisition and purchase order price. |
PriceUpdateTolerance | Value that identifies the maximum percentage increase allowed in a price or sales catalog update, 832 EDI transaction, sent by supplier. |
ProcurementOptionsPrcBuId | Value that uniquely identifies the procurement business unit. |
Rate | Value that uniquely identifies the currency conversion rate. |
RateDate | Value that uniquely identifies the currency conversion date. |
RateType | Value that uniquely identifies the currency conversion rate type. |
ReceiveCloseCode | Value that uniquely identifies the default receipt close point. |
ReceiveCloseTolerance | Value that uniquely identifies the default receipt close tolerance percent. |
ReceivingFlag | Check box that indicates whether you require receipt for items you order or not. |
ReleaseMethod | Release Method for ASL creation. This is applicable only for PA. |
ReqBuId | Value that uniquely identifies the requisitioning business unit. |
RetroPriceApplyUpdatesFlag | Indicates whether price updates on the agreement should be propagated to orders referencing the agreement. |
RetroPriceCommUpdatesFlag | Indicates whether orders that were repriced because of a price change on the referenced agreement should be communicated to the supplier. |
RetroPriceInitApprovalFlag | Indicates whether the retroactive price update background process should be initiated upon agreement approval. |
RetroPriceOpenOrderFlag | Indicates whether the retroactive price update background process should only reprice open unfulfilled orders referencing the agreement. |
RevisedDate | Date the document was last revised. |
RevisionNum | Value that uniquely identifies the document revision number. |
Segment1 | Value that uniquely identifies the order number. |
ServiceLevel | Level that indicates the priority of transportation that affects how quickly goods are transported. |
ServiceLevel1 | Level that indicates the priority of transportation that affects how quickly goods are transported. |
ShipToLocationId | Value that uniquely identifies the ship-to location. |
ShippingControl | Indicator of who's responsible for arranging transportation. |
SignatureRequiredFlag | Indicates if signatures are required on the document before it can be opened. |
SkipElectronicCommFlag | |
SoldtoLeId | Value that uniquely identified the sold-to legal entity. It Indicates the party that's financially responsible for the purchases on a purchase order. |
SourcingSuppEligibilityFlag | Check box that indicates whether to invite only sourcing eligible suppliers. |
StartDate | Value that identifies the effective date of the document. |
StyleId | Value that uniquely identifies the purchasing style of the document. |
StyleId1 | Value that uniquely identifies the purchasing style of the document. |
SubmitApprovalAutomatic | Check box that indicates whether the document can be automatically submitted for approval. |
SubmitDate | Date when the document was first submitted for approval. |
SupplierAuthoringAcceptance | Supplier acceptance level for agreement change. |
SupplierNotifMethod | Value that uniquely identifies the supplier communication method. |
TaxAttributeUpdateCode | Code that keeps track of create or update actions on this entity. |
TaxDocumentSubtype | Country Specific classification of the document used for tax calculation and reporting purposes. |
TermsId | Value that uniquely identifies the payment terms. |
TermsId1 | Value that uniquely identifies the payment terms. |
ThirdPtyRegId | Third party tax registration ID for the transaction. |
TypeLookupCode | Value that identifies the type of the document. Combined with segment1 and BU to form unique key, References the PO_DOCUMENT_TYPES_ALL_B.document_subtype. |
UseNeedByDate | Indicates whether the need-by date is used. |
UseSalesOrderNumberFlag | Check box that indicates whether requisition lines should be grouped by sales order number to create distinct purchase order. |
UseShipTo | Indicates whether the ship to organization and location is used. |
UseShipToForGroupReqs | Check box that indicates whether to use ship-to organization and location when grouping requisitions. |
UseShipToForGroupReqs1 | Check box that indicates whether to use ship-to organization and location when grouping requisitions. |
UserDefinedReceiptNumCode | Code that identifies the receipt numbering type. |
UserDefinedReqNumCode | Code that identifies the requisition numbering type. |
VendorContactId | Value that uniquely identifies the supplier contact. |
VendorId | Value that uniquely identifies the supplier. |
VendorOrderNum | Number that indicates the supplier document number. |
VendorSiteId | Value that uniquely identifies the supplier site. |