| Line | Field Name | Data Type | Description |
|---|---|---|---|
| 1 | str:purchaseInvoiceData | Table | Purchase invoice information from supplier purchase per accounts payable subsystem. |
| 2 | term:approvedBy | Term (Text/String) | User ID (from User_Listing file) for person who approved the entry. |
| 3 | term:approvedDateTime | Term (Date) | The DateTime the entry was approved. |
| 4 | term:batchId | Term (Text/String) | Systems generated ID for batch |
| 5 | term:billingAddressAdditionalAddressDetail | Term (Text/String) | |
| 6 | term:billingAddressAddressType | Term (Text/String) | Field to differentiate between multiple addresses. To indicate the type of address. Choose from the predefined enumeration. (examples: StreetAddress PostalAddress, BillingAddress) |
| 7 | term:billingAddressBuilding | Term (Text/String) | |
| 8 | term:billingAddressCity | Term (Text/String) | |
| 9 | term:billingAddressCountry | Term (Text/String) | Two-letter country code according to ISO 3166-1 alpha 2 standard. Example NL for the Netherlands. |
| 10 | term:billingAddressNumber | Term (Text/String) | |
| 11 | term:billingAddressPostalCode | Term (Text/String) | |
| 12 | term:billingAddressRegion | Term (Text/String) | Country specific code to indicate regions / provinces within the tax authority. Preferably described according to ISO 3166-2. Example: GB-KEN for Kent county in the United Kingdom. |
| 13 | term:billingAddressStreetName | Term (Text/String) | |
| 14 | term:branchStoreNumber | Term (Text/String) | Branch or Storenumber, additional segregation of customer/supplier, used if not included as part of the customer/supplier id |
| 15 | term:businessUnitCode | Term (Text/String) | Used to identify the business unit, region, branch, and so on at the level that financial statements are being audited and for which the trial balance is generated. For example, you may use a code aligned with the concept of a reportable segment as defined in FASB Accounting Standards Codification (ASC) 280, Segment Reporting. |
| 16 | term:glLineCreditAccountNumber | Term (Text/String) | GL account number on which the credit side of the transaction has been posted. |
| 17 | term:glLineDebitAccountNumber | Term (Text/String) | GL account number on which the debit side of the transaction has been posted. |
| 18 | term:glPostingDate | Term (Date) | Date posting to GL |
| 19 | term:glTax1CreditAccountNumber | Term (Text/String) | GL account number on which the credit side of the Tax1 transaction has been posted. |
| 20 | term:glTax1DebitAccountNumber | Term (Text/String) | GL account number on which the debit side of the Tax1 transaction has been posted. |
| 21 | term:glTax2CreditAccountNumber | Term (Text/String) | GL account number on which the credit side of the Tax2 transaction has been posted. |
| 22 | term:glTax2DebitAccountNumber | Term (Text/String) | GL account number on which the debit side of the Tax2 transaction has been posted. |
| 23 | term:glTax3CreditAccountNumber | Term (Text/String) | GL account number on which the credit side of the Tax3 transaction has been posted. |
| 24 | term:glTax3DebitAccountNumber | Term (Text/String) | GL account number on which the debit side of the Tax3 transaction has been posted. |
| 25 | term:invoiceAmount | Term (Decimal) | Transaction monetary amount recorded in the functional or group currency. No multicurrency translation should need to be performed on this amount because all transactions should be recorded in a single currency. |
| 26 | term:invoiceAmountCurrency | Term (Decimal) | The functional or group currency related to the invoice amount. See ISO 4217 coding. |
| 27 | term:invoiceAmountLocal | Term (Decimal) | Transaction monetary amount in local currency. Usually the amount seen on the original invoice document. |
| 28 | term:invoiceAmountReporting | Term (Decimal) | Transaction monetary amount recorded in the reporting currency. |
| 29 | term:invoiceDate | Term (Date) | The date of the invoice, regardless of the date the invoice is entered. This is the date from which the due date is calculated based on the invoice terms. |
| 30 | term:invoiceDocumentReference | Term (Text/String) | |
| 31 | term:invoiceDueDate | Term (Date) | The date payment is due from the customer. Aging of a receivable is usually calculated based on this date. |
| 32 | term:invoiceId | Term (Text/String) | Unique identifier for each invoice. This ID may need to be created by concatenating fields (for example, document number, document type, and year) to uniquely identify each transaction. The same ID must be used for all tables with invoice data (Invoices_Received_YYYYMMDD_YYYYMM DD, Open_Accounts_Payables_YYYYMMDD, AP_Cash_Application_YYYYMMDD_YYYYM MDD, and AP_Adjustments_YYYYMMDD_YYYYMMDD). |
| 33 | term:invoiceLineAmount | Term (Decimal) | Transaction monetary amount recorded in the functional or group currency. No multicurrency translation should need to be performed on this amount because all transactions should be recorded in a single currency. |
| 34 | term:invoiceLineAmountCurrencyAmount | Term (Decimal) | Transaction monetary amount in local currency. |
| 35 | term:invoiceLineAmountCurrencyCode | Term (Decimal) | The functional or group currency related to the invoice amount. See ISO 4217 coding. |
| 36 | term:invoiceLineAmountExchangeRate | Term (Decimal) | The exchange rate used. CurrencyAmount x ExchangeRate = Amount |
| 37 | term:invoiceLineAmountReporting | Term (Decimal) | Transaction monetary amount recorded in the reporting currency. |
| 38 | term:invoiceLocalCurrency | Term (Text/String) | The currency for local reporting requirements. See ISO 4217 coding. |
| 39 | term:invoiceNo | Term (Text/String) | Identification number for an externally generated invoice. |
| 40 | term:invoiceReportingCurrency | Term (Text/String) | The reporting currency related to the invoice reporting amount for nonconsolidated reporting. See ISO 4217 coding. |
| 41 | term:invoiceType | Term (Text/String) | Type of invoice: Debit invoice, Credit invoice, Cash, Ticket, etc |
| 42 | term:lineAccountId | Term (Text/String) | General Ledger Account code of the GL-revenue-account. Can be including sub-account id. It can contain many different levels to identify the Account. It could include cost centres such as company, division, region, group and branch/department. |
| 43 | term:lineAnalysisId | Term (Text/String) | Value of the analysisID: f.i. which cost center applies |
| 44 | term:lineAnalysisType | Term (Text/String) | Analysis code identifier: cost center, cost unit, cost type, project, etc. Refers to the MasterFile AnalysisTypeTable |
| 45 | term:lineApprovedBy | Term (Text/String) | User ID (from User_Listing file) for person who approved the entry. |
| 46 | term:lineApprovedDateTime | Term (Date) | The date and time the entry was approved. |
| 47 | term:lineCreditNoteReason | Term (Text/String) | Credit note reason or rationale |
| 48 | term:lineCreditNoteReference | Term (Text/String) | Credit note reference (where applicable) to original invoice |
| 49 | term:lineDebitCreditIndicator | Term (Text/String) | Indicates whether the amounts on line-level are debit or credit amounts. Entry must correspond to entry reflected in General Ledger Entry. Signing of line amounts is relative to this indicator. E.g. a return can lead to a negative amount |
| 50 | term:lineDeliveryDate | Term (Date) | The date of the delivery |
| 51 | term:lineDescription | Term (Text/String) | Description of Invoice Line. |
| 52 | term:lineFromDate | Term (Date) | Startdate of the deliveries |
| 53 | term:lineGoodsServicesId | Term (Text/String) | Indicator showing if goods or service |
| 54 | term:lineInvoiceDueDate | Term (Date) | The date payment is due to the supplier. Not all transactions will have a due date (for example, credit memos). Aging of a payable is usually calculated based on this date. |
| 55 | term:lineInvoiceLocalCurrency | Term (Text/String) | The currency for local reporting requirements. See ISO 4217 coding. |
| 56 | term:lineInvoiceUOM | Term (Decimal) | Quantity unit of measure e.g. pack of 12 |
| 57 | term:lineLineNumber | Term (Text/String) | Line item number of the invoice. |
| 58 | term:lineMovementReference | Term (Text/String) | Unique reference to the movement. |
| 59 | term:lineOrderDate | Term (Date) | Date of order |
| 60 | term:lineOriginatingON | Term (Text/String) | Origination Order Number |
| 61 | term:lineProductCode | Term (Text/String) | Unique identifier for each purchased product. This ID may need to be created by concatenating fields (for example, business unit, product number, year, and so on) to uniquely identify each product. |
| 62 | term:lineProductDescription | Term (Text/String) | Product (plain English) description to indicate the name or other identifying characteristics of the product. |
| 63 | term:lineProductGroup01 | Term (Text/String) | Product descriptor #1, for example, tires or accessories. |
| 64 | term:lineProductGroup02 | Term (Text/String) | Product descriptor #2, for example, brand. |
| 65 | term:linePurchaseOrderId | Term (Text/String) | Date of order |
| 66 | term:linePurchaseOrderLineId | Term (Text/String) | Identifier for purchase order line number. Must match Purchase_Order_Line_ID used in Purchase_Orders_Lines_YYYYMMDD_YYYYMMDD file. If no purchase order, leave blank. |
| 67 | term:lineQuantity | Term (Text/String) | Quantity of goods and services supplied. |
| 68 | term:lineReportingCurrency | Term (Text/String) | The reporting currency related to the invoice reporting amount for nonconsolidated reporting. See ISO 4217 coding. |
| 69 | term:lineShipFromAdditionalAddressDetail | Term (Text/String) | |
| 70 | term:lineShipFromAddressType | Term (Text/String) | Field to differentiate between multiple addresses. To indicate the type of address. Choose from the predefined enumeration. (examples: StreetAddress PostalAddress, BillingAddress) |
| 71 | term:lineShipFromBuilding | Term (Text/String) | |
| 72 | term:lineShipFromCity | Term (Text/String) | |
| 73 | term:lineShipFromCountry | Term (Text/String) | Two-letter country code according to ISO 3166-1 alpha 2 standard. Example NL for the Netherlands. |
| 74 | term:lineShipFromDeliveryDate | Term (Date) | Date goods are delivered |
| 75 | term:lineShipFromDeliveryId | Term (Text/String) | Identification of the delivery |
| 76 | term:lineShipFromLocationId | Term (Text/String) | Warehouse where goods held - also to identify work-in-progress, or stock-in-transit |
| 77 | term:lineShipFromNumber | Term (Text/String) | |
| 78 | term:lineShipFromPostalCode | Term (Text/String) | |
| 79 | term:lineShipFromRegion | Term (Text/String) | Country specific code to indicate regions / provinces within the tax authority. Preferably described according to ISO 3166-2. Example: GB-KEN for Kent county in the United Kingdom. |
| 80 | term:lineShipFromStreetName | Term (Text/String) | Unique consignment reference number |
| 81 | term:lineShipFromUCR | Term (Text/String) | Location of goods in warehouse |
| 82 | term:lineShipFromWarehouseId | Term (Text/String) | Warehouse where goods held - also to identify work-in-progress, or stock-in-transit |
| 83 | term:lineShippingCostsAmount | Term (Decimal) | In the headers default currency. |
| 84 | term:lineShippingCostsAmountCurrencyAmount | Term (Decimal) | Amount in foreign currency |
| 85 | term:lineShippingCostsAmountCurrencyCode | Term (Text/String) | Three-letter currency code according to ISO 4217 standard. Example: EUR for the Euros or USD for American Dollars. |
| 86 | term:lineShippingCostsAmountExchangeRate | Term (Decimal) | The exchange rate used. CurrencyAmount x ExchangeRate = Amount |
| 87 | term:lineShipToAdditionalAddressDetail | Term (Text/String) | |
| 88 | term:lineShipToAddressType | Term (Text/String) | Field to differentiate between multiple addresses. To indicate the type of address. Choose from the predefined enumeration. (examples: StreetAddress PostalAddress, BillingAddress) |
| 89 | term:lineShipToBuilding | Term (Text/String) | |
| 90 | term:lineShipToCity | Term (Text/String) | |
| 91 | term:lineShipToCountry | Term (Text/String) | Two-letter country code according to ISO 3166-1 alpha 2 standard. Example NL for the Netherlands. |
| 92 | term:lineShipToDeliveryDate | Term (Date) | Date goods are delivered |
| 93 | term:lineShipToDeliveryId | Term (Text/String) | Identification of the delivery |
| 94 | term:lineShipToLocationId | Term (Text/String) | Location of goods in warehouse |
| 95 | term:lineShipToNumber | Term (Text/String) | |
| 96 | term:lineShipToPostalCode | Term (Text/String) | |
| 97 | term:lineShipToRegion | Term (Text/String) | Country specific code to indicate regions / provinces within the tax authority. Preferably described according to ISO 3166-2. Example: GB-KEN for Kent county in the United Kingdom. |
| 98 | term:lineShipToStreetName | Term (Text/String) | |
| 99 | term:lineShipToUCR | Term (Text/String) | Unique consignment reference number |
| 100 | term:lineShipToWarehouseId | Term (Text/String) | Warehouse where goods held - also to identify work-in-progress, or stock-in-transit |
| 101 | term:lineSystemEntryDateTime | Term (Date) | The date the transaction was entered into the system. This is sometimes referred to as the creation date. This should be a system-generated date (rather than user-entered date), when possible. This date does not necessarily correspond with the date of the transaction itself. |
| 102 | term:lineSystemEntryUser | Term (Text/String) | User_ID (from User_Listing file) for person who created the record. |
| 103 | term:lineSystemModifiedDateTime | Term (Date) | The date and time the entry was last modified. |
| 104 | term:lineSystemModifiedUser | Term (Text/String) | User_ID (from User_Listing file) for the last person modifying this entry. |
| 105 | term:lineTaxInformationTaxAmount | Term (Decimal) | In the headers default currency. |
| 106 | term:lineTaxInformationTaxAmountCurrencyAmount | Term (Decimal) | Amount in foreign currency |
| 107 | term:lineTaxInformationTaxAmountCurrencyCode | Term (Text/String) | Three-letter currency code according to ISO 4217 standard. Example: EUR for the Euros or USD for American Dollars. |
| 108 | term:lineTaxInformationTaxAmountExchangeRate | Term (Decimal) | The exchange rate used. CurrencyAmount x ExchangeRate = Amount |
| 109 | term:lineTaxInformationTaxBase | Term (Text/String) | The base on which the tax is calculated. This can be an amount, or a quantity, eg. Litres. |
| 110 | term:lineTaxInformationTaxBaseDescription | Term (Text/String) | Description of the value in the TaxBase. Eg. Litres for excises on alcoholic bevarages. |
| 111 | term:lineTaxInformationTaxCode | Term (Text/String) | Tax Code for lookup in tables |
| 112 | term:lineTaxInformationTaxDeclarationPeriod | Term (Text/String) | The identification of the declaration/return in which the taxamount is reported to the Revenue body |
| 113 | term:lineTaxInformationTaxExemptionReason | Term (Text/String) | Tax exemption or reduction reason or rationale |
| 114 | term:lineTaxInformationTaxPercentage | Term (Decimal) | Tax percentage. |
| 115 | term:lineTaxPointDate | Term (Date) | Tax Point date where recorded or if not recorded then the Invoice date |
| 116 | term:lineToDate | Term (Date) | Enddate of the deliveries |
| 117 | term:lineUnitPrice | Term (Decimal) | Unit price for the unit/group of units per UOM in the headers default currency |
| 118 | term:lineUOMToUOMBaseConversionFactor | Term (Decimal) | Conversion factor of the InvoiceUOM to UOM Base. Only needed when InvoiceUOM is reported and is different from the UOM Base. |
| 119 | term:paymentTerms | Term (Text/String) | Payments terms for this invoice |
| 120 | term:period | Term (Text/String) | Fiscal period in which the Effective_Date occurs.Examples include W1‚W53 for weekly periods, M1‚M12 for monthly periods, and Q1‚Q4 for quarterly periods. |
| 121 | term:periodYear | Term (Text/String) | Fiscal year in which the Purchase_Order_Date occurred YYYY fordelimited, CCYY-MM-DD fiscal year end(ISO 8601) for extensible business reporting language global ledger taxonomy framework (XBRL GL). |
| 122 | term:postingStatus | Term (Text/String) | Status of the transactions posting to the GL (for example, Posted, Not Posted). |
| 123 | term:purchaseInvoiceLineNumber | Term (Text/String) | |
| 124 | term:purchaseInvoiceNumber | Term (Text/String) | |
| 125 | term:purchaseInvoiceUniqueId | Term (Text/String) | |
| 126 | term:purchaseOrderId | Term (Text/String) | Unique identifier for each purchase order. Must match Purchase_Order_ID in the Purchase_Orders_YYYYMMDD_YYYYMMDD file. If no purchase order, leave blank. |
| 127 | term:receiptNumbers | Term (Text/String) | The number(s) of the receipt(s) on this consolidated invoicerecord. Can be a single number, a range or a list. |
| 128 | term:segment01 | Term (Text/String) | Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on. |
| 129 | term:segment02 | Term (Text/String) | Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on. |
| 130 | term:segment03 | Term (Text/String) | Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on. |
| 131 | term:segment04 | Term (Text/String) | Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on. |
| 132 | term:segment05 | Term (Text/String) | Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on. |
| 133 | term:selfBillingIndicator | Term (Text/String) | Indicator showing if a self-billing agreement exists between the customer and the supplier |
| 134 | term:settlementAmount | Term (Decimal) | In the headers default currency. |
| 135 | term:settlementCurrencyAmount | Term (Decimal) | Amount in foreign currency |
| 136 | term:settlementCurrencyCode | Term (Text/String) | Three-letter currency code according to ISO 4217 standard. Example: EUR for the Euros or USD for American Dollars. |
| 137 | term:settlementExchangeRate | Term (Decimal) | The exchange rate used. CurrencyAmount x ExchangeRate = Amount |
| 138 | term:settlementPaymentMechanism | Term (Text/String) | Payment mechanism |
| 139 | term:settlementSettlementDate | Term (Date) | Date settled |
| 140 | term:settlementSettlementDiscount | Term (Decimal) | Description Settlement / Other Discount |
| 141 | term:shipFromAdditionalAddressDetail | Term (Text/String) | |
| 142 | term:shipFromAddressType | Term (Text/String) | Field to differentiate between multiple addresses. To indicate the type of address. Choose from the predefined enumeration. (examples: StreetAddress PostalAddress, BillingAddress) |
| 143 | term:shipFromBuilding | Term (Text/String) | |
| 144 | term:shipFromCity | Term (Text/String) | |
| 145 | term:shipFromCountry | Term (Text/String) | Two-letter country code according to ISO 3166-1 alpha 2 standard. Example NL for the Netherlands. |
| 146 | term:shipFromDeliveryDate | Term (Date) | Date goods are delivered |
| 147 | term:shipFromDeliveryId | Term (Text/String) | Identification of the delivery |
| 148 | term:shipFromLocationId | Term (Text/String) | Location of goods in warehouse |
| 149 | term:shipFromNumber | Term (Text/String) | |
| 150 | term:shipFromPostalCode | Term (Text/String) | |
| 151 | term:shipFromRegion | Term (Text/String) | Country specific code to indicate regions / provinces within the tax authority. Preferably described according to ISO 3166-2. Example: GB-KEN for Kent county in the United Kingdom. |
| 152 | term:shipFromStreetName | Term (Text/String) | |
| 153 | term:shipFromUCR | Term (Text/String) | Unique consignment reference number |
| 154 | term:shipFromWarehouseId | Term (Text/String) | Warehouse where goods held - also to identify work-in-progress, or stock-in-transit |
| 155 | term:shipToAdditionalAddressDetail | Term (Text/String) | |
| 156 | term:shipToAddressType | Term (Text/String) | Field to differentiate between multiple addresses. To indicate the type of address. Choose from the predefined enumeration. (examples: StreetAddress PostalAddress, BillingAddress) |
| 157 | term:shipToBuilding | Term (Text/String) | |
| 158 | term:shipToCity | Term (Text/String) | |
| 159 | term:shipToCountry | Term (Text/String) | Two-letter country code according to ISO 3166-1 alpha 2 standard. Example NL for the Netherlands. |
| 160 | term:shipToDeliveryDate | Term (Date) | Date goods are delivered |
| 161 | term:shipToDeliveryId | Term (Text/String) | Identification of the delivery |
| 162 | term:shipToLocationId | Term (Text/String) | Location of goods in warehouse |
| 163 | term:shipToNumber | Term (Text/String) | |
| 164 | term:shipToPostalCode | Term (Text/String) | |
| 165 | term:shipToRegion | Term (Text/String) | Country specific code to indicate regions / provinces within the tax authority. Preferably described according to ISO 3166-2. Example: GB-KEN for Kent county in the United Kingdom. |
| 166 | term:shipToStreetName | Term (Text/String) | |
| 167 | term:shipToUCR | Term (Text/String) | Unique consignment reference number |
| 168 | term:shipToWarehouseId | Term (Text/String) | Warehouse where goods held - also to identify work-in-progress, or stock-in-transit |
| 169 | term:sourceId | Term (Text/String) | Posting source (code for source from which the journal entry originated, such as sales journal, cash receipts journal, general journal, payroll journal, accountant manual entry, spreadsheet, and so on). |
| 170 | term:supplierId | Term (Text/String) | Identifier of the supplier to whom payment is due or from whom unused credits have been applied. Must match the Supplier_Account_ID in the Supplier_Listing_YYYYMMDD file. |
| 171 | term:supplierName | Term (Text/String) | Name of the supplier |
| 172 | term:systemEntryDateTime | Term (Date) | The date the transaction was entered into the system. This is sometimes referred to as the creation date. This should be a system-generated date (rather than user-entered date), when possible. This date does not necessarily correspond with the date of the transaction itself. |
| 173 | term:systemEntryUser | Term (Text/String) | User_ID (from User_Listing file) for person who created the record. |
| 174 | term:systemId | Term (Text/String) | Unique number created by the system for the document |
| 175 | term:systemModifiedDateTime | Term (Date) | The date and time the entry was last modified. |
| 176 | term:systemModifiedUser | Term (Text/String) | User_ID (from User_Listing file) for the last person modifying this entry. |
| 177 | term:tax1Local | Term (Text/String) | The amount of Tax1_Type included in the transaction. Recorded in local currency. |
| 178 | term:tax1Type | Term (Text/String) | Code for Tax1 type (for example, Sales, VAT). This field should agree with the Regulator_Code field in the Tax_Table_YYYYMMDD |
| 179 | term:tax1TypeDescription | Term (Text/String) | Description of Tax1 type (for example, authority tax is paid to and other information to identify tax). |
| 180 | term:tax2Local | Term (Text/String) | The amount of Tax2_Type included in the transaction. Recorded in local currency. |
| 181 | term:tax2Type | Term (Text/String) | Code for Tax2 type (for example, Sales, VAT). This field should agree with the Regulator_Code field in the Tax_Table_YYYYMMDD |
| 182 | term:tax2TypeDescription | Term (Text/String) | Description of Tax2 type (for example, authority tax is paid to and other information to identify tax). |
| 183 | term:tax3Local | Term (Text/String) | The amount of Tax3_Type included in the transaction. Recorded in local currency. |
| 184 | term:tax3Type | Term (Text/String) | Code for Tax3 type (for example, Sales, VAT). This field should agree with the Regulator_Code field in the Tax_Table_YYYYMMDD |
| 185 | term:tax3TypeDescription | Term (Text/String) | Description of Tax3 type (for example, authority tax is paid to and other information to identify tax). |
| 186 | term:termsDiscountDays | Term (Text/String) | The number of days from the invoice date the supplier allows to take advantage of discounted terms. Terms are represented as digits with no decimal places (for example, nnn). |
| 187 | term:termsDiscountPercentage | Term (Decimal) | The discount percentage the supplier may provide if an invoice is paid before a certain number of days. In the flat file, terms are represented as digits to one decimal place (for example, 10% would be represented as 10.0). In extensible business reporting language global ledger taxonomy framework (XBRL GL), the three fields Terms_Discount_Percentage, Terms_Discount_Days and Terms_Due_Days would be entered in the form xx.x% dd Net dd, such as 2% 10 Net 30 for 2% discount if paid within 10 days, with the net due in 30 days. |
| 188 | term:termsDueDays | Term (Text/String) | The number of days allowed to meet the obligation before an invoice becomes overdue. |
| 189 | term:transactionId | Term (Text/String) | Cross-reference to GL posting. It can contain many different levels to identify the transaction. It could include cost centres such as company, division, region, group and branch/department |