salesInvoiceData

11/20/2020 12:35:29 PM

Line Field Name Data Type Description
1 str:salesInvoiceData Table Sales invoice information to customer from accounts receivable 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:customerInfoCustomerId Term (Text/String) Identifier of the customer from whom payment is expected or to whom unused credits have been applied. Must match a Customer_Account_ID in the Customer_Master_Listing_YYYYMMDD file.
17 term:customerInfoName Term (Text/String) Name of the customer
18 term:glLineCreditAccountNumber Term (Text/String) GL account number on which the credit side of the transaction has been posted.
19 term:glLineDebitAccountNumber Term (Text/String) GL account number on which the debit side of the transaction has been posted.
20 term:glPostingDate Term (Date) Date posting to GL
21 term:glTax1CreditAccountNumber Term (Text/String) GL account number on which the credit side of the Tax1 transaction has been posted.
22 term:glTax1DebitAccountNumber Term (Text/String) GL account number on which the debit side of the Tax1 transaction has been posted.
23 term:glTax2CreditAccountNumber Term (Text/String) GL account number on which the credit side of the Tax2 transaction has been posted.
24 term:glTax2DebitAccountNumber Term (Text/String) GL account number on which the debit side of the Tax2 transaction has been posted.
25 term:glTax3CreditAccountNumber Term (Text/String) GL account number on which the credit side of the Tax3 transaction has been posted.
26 term:glTax3DebitAccountNumber Term (Text/String) GL account number on which the debit side of the Tax3 transaction has been posted.
27 term:groupingCode Term (Text/String) Grouping mechanism for related items in a batch or grouping of invoices, such as the invoice grouping found in certain ERP systems
28 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.
29 term:invoiceAmountCurrency Term (Decimal) The functional or group currency related to the invoice amount. See ISO 4217 coding.
30 term:invoiceAmountLocal Term (Decimal) Transaction monetary amount in local currency. Usually the amount seen on the original invoice document.
31 term:invoiceAmountReporting Term (Decimal) Transaction monetary amount recorded in the reporting currency.
32 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.
33 term:invoiceDocumentReference Term (Text/String)
34 term:invoiceDueDate Term (Date) The date payment is due from the customer. Aging of a receivable is usually calculated based on this date.
35 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).
36 term:invoiceLineAmountReporting Term (Decimal) Transaction monetary amount recorded in the reporting currency.
37 term:invoiceLineLocalCurrency Term (Text/String) The currency for local reporting requirements. See ISO 4217 coding.
38 term:invoiceLineReportingCurrency Term (Text/String) The reporting currency related to the invoice reporting amount for non consolidated reporting. See ISO4217 coding.
39 term:invoiceLocalCurrency Term (Text/String) The currency for local reporting requirements. See ISO 4217 coding.
40 term:invoiceNo Term (Text/String) Identification number for an externally generated invoice.
41 term:invoiceReportingCurrency Term (Text/String) The reporting currency related to the invoice reporting amount for nonconsolidated reporting. See ISO 4217 coding.
42 term:invoiceType Term (Text/String) Type of invoice: Debit invoice, Credit invoice, Cash, Ticket, etc
43 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.
44 term:lineAnalysisAmount 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.
45 term:lineAnalysisAmountCurrencyAmount Term (Decimal) Transaction monetary amount in local currency.
46 term:lineAnalysisAmountCurrencyCode Term (Text/String) The functional or group currency related to the invoice amount. See ISO 4217 coding.
47 term:lineAnalysisAmountExchangeRate Term (Decimal) The exchange rate used. CurrencyAmount x ExchangeRate = Amount
48 term:lineAnalysisId Term (Text/String) Value of the analysisID: f.i. which cost center applies
49 term:lineAnalysisType Term (Text/String) Analysis code identifier: cost center, cost unit, cost type, project, etc. Refers to the MasterFile AnalysisTypeTable
50 term:lineApprovedBy Term (Text/String) User ID (from User_Listing file) for person who approved the entry.
51 term:lineApprovedDateTime Term (Date) The date and time the entry was approved.
52 term:lineCreditNoteReason Term (Text/String) Credit note reason or rationale
53 term:lineCreditNoteReference Term (Text/String) Credit note reference (where applicable) to original invoice
54 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
55 term:lineDeliveryDate Term (Date) The date of the delivery
56 term:lineDescription Term (Text/String) Description of Invoice Line.
57 term:lineFromDate Term (Date) Startdate of the deliveries
58 term:lineGoodsServicesId Term (Text/String) Indicator showing if goods or service
59 term:lineGroupingCode Term (Text/String) Grouping mechanism for related items in a batch or grouping of invoices, such as the invoice grouping found in certain ERP systems
60 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.
61 term:lineInvoiceLineAmount Term (Decimal) In the headers default currency.
62 term:lineInvoiceLineAmountCurrencyAmount Term (Decimal) Amount in foreign currency
63 term:lineInvoiceLineAmountCurrencyCode Term (Text/String) Three-letter currency code according to ISO 4217 standard. Example: EUR for the Euros or USD for American Dollars.
64 term:lineInvoiceLineAmountExchangeRate Term (Decimal) The exchange rate used. CurrencyAmount x ExchangeRate = Amount
65 term:lineInvoiceProductGroup01 Term (Text/String) Product descriptor #1, for example, tires or accessories.
66 term:lineInvoiceProductGroup02 Term (Text/String) Product descriptor #1, for example, tires or accessories.
67 term:lineInvoiceUOM Term (Decimal) Quantity unit of measure e.g. pack of 12
68 term:lineLineNumber Term (Text/String) Line item number of the invoice.
69 term:lineMovementReference Term (Text/String) Unique reference to the movement.
70 term:lineOrderDate Term (Date) Date of order
71 term:lineOriginatingON Term (Text/String) Origination Order Number
72 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.
73 term:lineProductDescription Term (Text/String) Product (plain English) description to indicate the name or other identifying characteristics of the product.
74 term:lineQuantity Term (Text/String) Quantity of goods and services supplied.
75 term:lineSalesOrderId Term (Text/String) Sales order ID for invoiced items. Must match Sales_Order_ID in the Sales_Orders_YYYYMMDD_YYYYMM DD file. If no sales order, leave blank.
76 term:lineSalesOrderLineId Term (Text/String) Identifier for sales order line number. Must match Sales_Order_Line_ID used in Sales_Orders_Lines_YYYYMMDD_YYYYMMDD file. If no sales order, leave blank.
77 term:lineShipFromAdditionalAddressDetail Term (Text/String)
78 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)
79 term:lineShipFromBuilding Term (Text/String)
80 term:lineShipFromCity Term (Text/String)
81 term:lineShipFromCountry Term (Text/String) Two-letter country code according to ISO 3166-1 alpha 2 standard. Example NL for the Netherlands.
82 term:lineShipFromDeliveryDate Term (Date) Date goods are delivered
83 term:lineShipFromDeliveryId Term (Text/String) Identification of the delivery
84 term:lineShipFromLocationId Term (Text/String) Warehouse where goods held - also to identify work-in-progress, or stock-in-transit
85 term:lineShipFromNumber Term (Text/String)
86 term:lineShipFromPostalCode Term (Text/String)
87 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.
88 term:lineShipFromStreetName Term (Text/String) Unique consignment reference number
89 term:lineShipFromUCR Term (Text/String) Location of goods in warehouse
90 term:lineShipFromWarehouseId Term (Text/String) Warehouse where goods held - also to identify work-in-progress, or stock-in-transit
91 term:lineShippingCostsAmount Term (Decimal) In the headers default currency.
92 term:lineShippingCostsAmountCurrencyAmount Term (Decimal) Amount in foreign currency
93 term:lineShippingCostsAmountCurrencyCode Term (Text/String) Three-letter currency code according to ISO 4217 standard. Example: EUR for the Euros or USD for American Dollars.
94 term:lineShippingCostsAmountExchangeRate Term (Decimal) The exchange rate used. CurrencyAmount x ExchangeRate = Amount
95 term:lineShipToAdditionalAddressDetail Term (Text/String)
96 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)
97 term:lineShipToBuilding Term (Text/String)
98 term:lineShipToCity Term (Text/String)
99 term:lineShipToCountry Term (Text/String) Two-letter country code according to ISO 3166-1 alpha 2 standard. Example NL for the Netherlands.
100 term:lineShipToDeliveryDate Term (Date) Date goods are delivered
101 term:lineShipToDeliveryId Term (Text/String) Identification of the delivery
102 term:lineShipToLocationId Term (Text/String) Location of goods in warehouse
103 term:lineShipToNumber Term (Text/String)
104 term:lineShipToPostalCode Term (Text/String)
105 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.
106 term:lineShipToStreetName Term (Text/String)
107 term:lineShipToUCR Term (Text/String) Unique consignment reference number
108 term:lineShipToWarehouseId Term (Text/String) Warehouse where goods held - also to identify work-in-progress, or stock-in-transit
109 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.
110 term:lineSystemEntryUser Term (Text/String) User_ID (from User_Listing file) for person who created the record.
111 term:lineSystemModifiedDateTime Term (Date) The date and time the entry was last modified.
112 term:lineSystemModifiedUser Term (Text/String) User_ID (from User_Listing file) for the last person modifying this entry.
113 term:lineTaxInformationTaxAmount Term (Decimal) In the headers default currency.
114 term:lineTaxInformationTaxAmountCurrencyAmount Term (Decimal) Amount in foreign currency
115 term:lineTaxInformationTaxAmountCurrencyCode Term (Text/String) Three-letter currency code according to ISO 4217 standard. Example: EUR for the Euros or USD for American Dollars.
116 term:lineTaxInformationTaxAmountExchangeRate Term (Decimal) The exchange rate used. CurrencyAmount x ExchangeRate = Amount
117 term:lineTaxInformationTaxBase Term (Text/String) The base on which the tax is calculated. This can be an amount, or a quantity, eg. Litres.
118 term:lineTaxInformationTaxBaseDescription Term (Text/String) Description of the value in the TaxBase. Eg. Litres for excises on alcoholic bevarages.
119 term:lineTaxInformationTaxCode Term (Text/String) Tax Code for lookup in tables
120 term:lineTaxInformationTaxDeclarationPeriod Term (Text/String) The identification of the declaration/return in which the taxamount is reported to the Revenue body
121 term:lineTaxInformationTaxExemptionReason Term (Text/String) Tax exemption or reduction reason or rationale
122 term:lineTaxInformationTaxPercentage Term (Decimal) Tax percentage.
123 term:lineTaxPointDate Term (Date) Tax Point date where recorded or if not recorded then the Invoice date
124 term:lineToDate Term (Date) Enddate of the deliveries
125 term:lineUnitPrice Term (Decimal) Unit price for the unit/group of units per UOM in the headers default currency
126 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.
127 term:paymentTerms Term (Text/String) Payments terms for this invoice
128 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.
129 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).
130 term:postingStatus Term (Text/String) Status of the transactions posting to the GL (for example, Posted, Not Posted).
131 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.
132 term:salesOrderId Term (Text/String) Sales order ID for invoiced items. Must match Sales_Order_ID in the Sales_Orders_YYYYMMDD_YYYYMMDD file. If no sales order, leave blank.
133 term:segment01 Term (Text/String) Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on.
134 term:segment02 Term (Text/String) Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on.
135 term:segment03 Term (Text/String) Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on.
136 term:segment04 Term (Text/String) Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on.
137 term:segment05 Term (Text/String) Reserved segment field that can be used for profit center, division, fund, program, branch, project, and so on.
138 term:selfBillingIndicator Term (Text/String) Indicator showing if a self-billing agreement exists between the customer and the supplier
139 term:settlementAmount Term (Decimal) In the headers default currency.
140 term:settlementCurrencyAmount Term (Decimal) Amount in foreign currency
141 term:settlementCurrencyCode Term (Text/String) Three-letter currency code according to ISO 4217 standard. Example: EUR for the Euros or USD for American Dollars.
142 term:settlementExchangeRate Term (Decimal) The exchange rate used. CurrencyAmount x ExchangeRate = Amount
143 term:settlementPaymentMechanism Term (Text/String) Payment mechanism
144 term:settlementSettlementDate Term (Date) Date settled
145 term:settlementSettlementDiscount Term (Decimal) Description Settlement / Other Discount
146 term:shipFromAdditionalAddressDetail Term (Text/String)
147 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)
148 term:shipFromBuilding Term (Text/String)
149 term:shipFromCity Term (Text/String)
150 term:shipFromCountry Term (Text/String) Two-letter country code according to ISO 3166-1 alpha 2 standard. Example NL for the Netherlands.
151 term:shipFromDeliveryDate Term (Date) Date goods are delivered
152 term:shipFromDeliveryId Term (Text/String) Identification of the delivery
153 term:shipFromLocationId Term (Text/String) Location of goods in warehouse
154 term:shipFromNumber Term (Text/String)
155 term:shipFromPostalCode Term (Text/String)
156 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.
157 term:shipFromStreetName Term (Text/String)
158 term:shipFromUCR Term (Text/String) Unique consignment reference number
159 term:shipFromWarehouseId Term (Text/String) Warehouse where goods held - also to identify work-in-progress, or stock-in-transit
160 term:shipToAdditionalAddressDetail Term (Text/String)
161 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)
162 term:shipToBuilding Term (Text/String)
163 term:shipToCity Term (Text/String)
164 term:shipToCountry Term (Text/String) Two-letter country code according to ISO 3166-1 alpha 2 standard. Example NL for the Netherlands.
165 term:shipToDeliveryDate Term (Date) Date goods are delivered
166 term:shipToDeliveryId Term (Text/String) Identification of the delivery
167 term:shipToLocationId Term (Text/String) Location of goods in warehouse
168 term:shipToNumber Term (Text/String)
169 term:shipToPostalCode Term (Text/String)
170 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.
171 term:shipToStreetName Term (Text/String)
172 term:shipToUCR Term (Text/String) Unique consignment reference number
173 term:shipToWarehouseId Term (Text/String) Warehouse where goods held - also to identify work-in-progress, or stock-in-transit
174 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).
175 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.
176 term:systemEntryUser Term (Text/String) User_ID (from User_Listing file) for person who created the record.
177 term:systemId Term (Text/String) Unique number created by the system for the document
178 term:systemModifiedDateTime Term (Date) The date and time the entry was last modified.
179 term:systemModifiedUser Term (Text/String) User_ID (from User_Listing file) for the last person modifying this entry.
180 term:tax1Local Term (Text/String) The amount of Tax1_Type included in the transaction. Recorded in local currency.
181 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
182 term:tax1TypeDescription Term (Text/String) Description of Tax1 type (for example, authority tax is paid to and other information to identify tax).
183 term:tax2Local Term (Text/String) The amount of Tax2_Type included in the transaction. Recorded in local currency.
184 term:tax2TypeDescription Term (Text/String) Description of Tax2 type (for example, authority tax is paid to and other information to identify tax).
185 term:tax3Local Term (Text/String) The amount of Tax3_Type included in the transaction. Recorded in local currency.
186 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
187 term:tax3TypeDescription Term (Text/String) Description of Tax3 type (for example, authority tax is paid to and other information to identify tax).
188 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).
189 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.
190 term:termsDueDays Term (Text/String) The number of days allowed to meet the obligation before an invoice becomes overdue.
191 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