| Line | Field Name | Data Type | Description |
|---|---|---|---|
| 1 | str:supplierMasterData | Table | Supplier or vendor master data by supplier record per accounts payable subsystem. |
| 2 | term:accountId | Term (Text/String) | General Ledger Account code for this supplier. 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. |
| 3 | term:additionalAddressDetail | Term (Text/String) | |
| 4 | term:addressAddressType | Term (Text/String) | Field to differentiate between multiple addresses. To indicate the type of address. Choose from the predefined enumeration. (examples: StreetAddress PostalAddress, BillingAddress) |
| 5 | term:addressBuilding | Term (Text/String) | The physical street address line 2 of the supplier. |
| 6 | term:addressCity | Term (Text/String) | The physical city where the customer is located. |
| 7 | term:addressCountry | Term (Text/String) | The country code where the supplier is physically located. Recommend ISO 3166-1 Alpha 2 or ISO 3166-1 Alpha 3 format (XX or XXX). |
| 8 | term:addressNumber | Term (Text/String) | The physical street address line 1 of the supplier. |
| 9 | term:addressPostalCode | Term (Text/String) | The zip code of the city where the customer is physically located. |
| 10 | term:addressRegion | Term (Text/String) | The physical state or province where the customer is located. Recommend ISO 3166-2. |
| 11 | term:addressStreetName | Term (Text/String) | The physical Street where the customer is located. |
| 12 | term:bankAccountId | Term (Text/String) | Unambiguous identification of the account to which credit and debit entries are made. |
| 13 | term:bankAccountName | Term (Text/String) | The name of the individual or company holding the bank account. |
| 14 | term:bankAccountNumber | Term (Text/String) | The number allocated to the account by the individuals or companys own bank. |
| 15 | term:companyType | Term (Text/String) | |
| 16 | term:effectiveDate | Term (Date) | Date the customer declared active. |
| 17 | term:email | Term (Text/String) | Email address of the primary contact. |
| 18 | term:expirationDate | Term (Date) | Date the customer was declared inactive. |
| 19 | term:fax | Term (Text/String) | |
| 20 | term:firstName | Term (Text/String) | The first (given) name of the person. |
| 21 | term:IBANNumber | Term (Text/String) | International Bank Account Number, ISO 13616 |
| 22 | term:lastName | Term (Text/String) | The last (family) name of the person. |
| 23 | term:legalEntityIdentifier | Term (Text/String) | |
| 24 | term:name | Term (Text/String) | The name of the supplier. |
| 25 | term:paymentDiscountDays | 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). |
| 26 | term:paymentDiscountPercentage | 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. |
| 27 | term:paymentDueDays | Term (Text/String) | The number of days allowed to meet the obligation before an invoice becomes overdue. |
| 28 | term:registrationNumber | Term (Text/String) | Unique number to identify the company in the accounting records, issued by a government authority or created by the company for internal purposes to identify different entities within their corporate group. |
| 29 | term:selfBillingIndicator | Term (Text/String) | Indicator showing if a self-billing agreement exists between the customer and the supplier |
| 30 | term:sortCode | Term (Text/String) | Identifier for the bank branch at which the account is held. May be needed to uniquely identify the account. |
| 31 | term:supplierCreditLimit | Term (Text/String) | The credit limit for the total outstanding balance approved for the supplier. |
| 32 | term:supplierGroup | Term (Text/String) | If the organization segments suppliers into groups, the group to which this supplier is assigned. |
| 33 | 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. |
| 34 | term:supplierType | Term (Text/String) | |
| 35 | term:systemApprovedDateTime | Term (Date) | The date and time the entry was approved. |
| 36 | term:systemApprovedUser | Term (Text/String) | User ID (from User_Listing file) for person who approved the entry. |
| 37 | 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. |
| 38 | term:systemEntryUser | Term (Text/String) | User_ID (from User_Listing file) for person who created the record. |
| 39 | term:systemModifiedDateTime | Term (Date) | The date and time the entry was last modified. |
| 40 | term:systemModifiedUser | Term (Text/String) | User_ID (from User_Listing file) for the last person modifying this entry. |
| 41 | term:taxAuthority | Term (Text/String) | Identification of the Revenue Body to which this TaxType refers. |
| 42 | term:taxNumber | Term (Text/String) | The suppliers tax identification number. |
| 43 | term:taxRegistrationNumber | Term (Text/String) | Unique number issued by a Revenue Body for use by the company. |
| 44 | term:taxType | Term (Text/String) | Tax type for look-up in tables |
| 45 | term:taxVerificationDate | Term (Date) | The date that the tax registration details referred to above were last checked. |
| 46 | term:telephone | Term (Text/String) | Phone number of the primary contact at the supplier. |
| 47 | term:title | Term (Text/String) | The title of the person (for example, accounting manager). |
| 48 | term:transactionCreditLimit | Term (Text/String) | The per invoice credit limit established with this supplier. |
| 49 | term:website | Term (Text/String) |