Available Data Elements in the Extract

This section discusses the data elements in the extract.

Available Data Elements in the Payables Invoice Extract

This table displays the data elements in the Payables invoice extract:

Source	Available Data Elements
Invoice header details	Invoice Number, Invoice Date, Invoice Type Lookup Code, Invoice Currency Code, Tax Currency Code, Terms Date, Description, Source, Project Name, Project Number, Contract Number, Identifying PO, Receipt Number, Payment Terms Name, Note Type Code, Note Text Previous Invoice Number, Previous Invoice Date, and Previous Invoice Type Lookup Code. Invoice Third Party Tax Reg Number, Goods Received Date, Invoice Received Date, and Additional Comments. Descriptive flexfields and context, and Global descriptive flexfields and context. Final Invoice, Payment Status, and Product Type. Exchange Rate Type, Exchange Rate, and Exchange Rate Date. Document Sub Type and Document Sub Type Code.
Invoice line details	Line Number, Line Type Lookup Code, Line Description, Item Description, UOM Code, and UOM Description. Product Type, Quantity Invoiced, Unit Price, Project Name, Project Number, and Contract Number. PO Number, PO Line Number, PO Discount Type, PO Discount Amount, PO Discount Base Amount, and PO Discount Reason. Receipt Number, Receipt Line Number, and Receipt Date. Previous Invoice Number, Previous Invoice Date, Previous Invoice Type, and Previous Invoice Line Number. Ship To Address Line1-3, Building, Floor Number, Province, County, City, Postal Code, State, and Country. Transaction Business Category and Name. Product Fiscal Classification Code and Name with assigned Tax Reporting Type and Tax Reporting Code. Intended Use Code and Name with assigned Tax Reporting Type and Tax Reporting Code. Product Type, Product Category Code, and Name. User Defined Fiscal Classification Code and Name with assigned Tax Reporting Type and Tax Reporting Code. Tax Classification. Descriptive flexfields and context.
Tax line details and Tax rates details	Tax Point Basis. Taxable Amount in ledger and tax currency. Tax Amount in ledger and tax currency. Tax Rate Type, Tax Reporting Type, Tax Reporting Code, Legal Message Flag and Legal Justification Text. Exempt Reason, Exempt Reason Code.
Supplier details	Supplier Name, Supplier Alternate Name, Supplier Income Tax ID, Supplier Email Address, Supplier Address Line1-4, Building, Floor Number, Province, County, City, Postal Code, State, Country, Phone, and Third Party Registration Number.
Legal Entity Information	Legal Entity Name, Legal Entity Address Line1-4, Building, Floor Number, Province, County, City, Postal Code, State, Country, Primary Legal Entity Phone, Primary Contact Name, Primary Contact Email Address, LRU Registration Number, Legal Entity Registration Number, Legal Entity Identifier, and First Party Registration number. Legal Entity descriptive flexfields and context.
Installment	Payment Number, Payment Status Flag, Payment Method Code, Payment Method Name, Bank Account Number, Bank Account Name, Bank Name, and Bank Legal Entity details when Legal Entity is different from Invoice Legal Entity.
Item details	Trading Partner Item, Trading Partner Item Description, Item Number, and Item Category Name. Item Description in US language. Descriptive flexfields and context.

Available Data Elements in the Life Cycle Refused Extract

This table displays the data elements in the Life Cycle Refused extract:

Source	Available Data Elements
Invoice details	Invoice Number, Invoice Type Lookup Code, Invoice Product Type, Invoice Payment Status, Invoice Received Date, Invoice Creation Date, Final Invoice Flag, and Job Start Time.
Supplier details	Supplier Name, Supplier Alternate Name, Supplier Site Name, Supplier Income Tax ID, Supplier Email Address, Supplier Address Line1-4, Building, Floor Number, Province, County, City, Postal Code, State, Country, Phone, and Third Party Registration Number.
Legal Entity Information	Legal Entity Name, Legal Entity Address Line1-4, Building, Floor Number, Province, County, City, Postal Code, State, Country, Primary Legal Entity Phone, Primary Contact Name, Primary Contact Email Address, LRU Registration Number, Legal Entity Registration Number, and Legal Entity Identifier. Legal Entity descriptive flexfields and context.
Invoice Hold	Hold Code, Hold Name, Hold Reason.

Available Data Elements in the Life Cycle Collected Extract

This table displays the data elements in the Life Cycle Collected extract:

Source	Available Data Elements
Receipt and Transaction details	Receipt Number, Transaction Number, Transaction class, Invoice Type Lookup Code, Job Start Time, Amount Applied, Receipt Amount, Amount Remaining, Printing Last Printed, Product Type, Payment Status, Final Invoice Flag, Third Party Registration Number, Receipt Currency Code, Apply Date, and Trx Creation Date.
Legal Entity Information	Legal Entity Name, Legal Entity Address Line1-4, Building, Floor Number, Province, County, City, Postal Code, State, Country, Primary Legal Entity Phone, Primary Contact Name, Primary Contact Email Address, LRU Registration Number, Legal Entity Registration Number, Legal Entity Identifier, and First Party Registration number. Legal Entity descriptive flexfields and context.
Bill To Customer details	Customer Name, Customer Account Number, and Country.