Version: 1.0
Attribute ID | Datatype | Data length | Nullabe ? | Label | Description |
---|---|---|---|---|---|
BILLING_ADDRESS | VARCHAR2 | 4000 | Y | Billing address | Contact address (street, number, address complement) |
BILLING_CONTACT | VARCHAR2 | 831 | Y | Billing contact | Contact name in format: "last name, first name (contact number)". No contact number if only beneficiary. |
BILLING_CONTACT_COUNTRY_CODE | VARCHAR2 | 20 | Y | Address country code | |
BILLING_CONTACT_EMAIL | VARCHAR2 | 254 | Y | Billing contact email | Email address of contact |
BILLING_CONTACT_STRUCTURE | VARCHAR2 | 400 | Y | Billing contact structure | Name of the company/organization the contact belongs to |
BILLING_CONTACT_TELEPHONE | VARCHAR2 | 31 | Y | Billing contact telephone | Phone number incl. Prefix |
BILLING_CONTACT_TOWN | VARCHAR2 | 20 | Y | Billing contact town | Town of address |
BILLING_CONTACT_ZIPCODE | VARCHAR2 | 20 | Y | Billing contact zip code | Postal code |
CANCELLATION_DATE | VARCHAR2 | 10 | Y | Date of invoice cancelled by current invoice | |
CANCELLATION_INVOICE_NUMBER | VARCHAR2 | 400 | Y | Cancellation invoice | Number of invoice cancelled by current invoice |
CATALOG_CURRENCY_CODE | VARCHAR2 | 4000 | Y | Currency code of catalog | |
CURRENCY_CODE | CHAR | 3 | N | Currency | Invoicing currency code |
DUE_AMT_ITX | NUMBER | 22 | Y | Amount remaining to be paid | |
EXPORT_DATE | VARCHAR2 | 10 | Y | Export date | Date of export to accounting system |
FILE_CONTACT | VARCHAR2 | 831 | Y | File contact | Name of contact of the invoiced file in format: "lastname,firstname(contact number)" |
FILE_CONTACT_ADDR_COUNTRY_CODE | VARCHAR2 | 2 | Y | Address country code | |
FILE_CONTACT_ADDR_TOWN | VARCHAR2 | 400 | Y | Town of address | |
FILE_CONTACT_ADDR_ZIPCODE | VARCHAR2 | 20 | Y | Postal code | |
FILE_CONTACT_EMAIL | VARCHAR2 | 254 | Y | File contact email | Email address of contact |
FILE_CONTACT_TELEPHONE | VARCHAR2 | 31 | Y | File contact telephone | Phone number incl. Prefix |
FILE_NUMBER | VARCHAR2 | 4000 | Y | File number | File number |
FURTHEST_INSTALLMNT_DATE | DATE | 7 | Y | Date of last installment | |
INSTIT_CODE | VARCHAR2 | 15 | N | Institution code | |
INVOICE_AMT_ITX | NUMBER | 22 | Y | Invoice amount | |
INVOICE_DATE | VARCHAR2 | 10 | Y | Invoice date | Invoice date |
INVOICE_NUMBER | VARCHAR2 | 400 | N | Invoice number | Invoice number |
KIND | VARCHAR2 | 4000 | Y | Invoice type. Possible values are: - invoice - credit note |
|
LAST_UPDATE | TIMESTAMP(6) WITH TIME ZONE | 13 | Y | Date of last update of report data | |
NB_OF_INSTALLMENTS | NUMBER | 22 | Y | Nb. of installments | Number of installments |
NEXT_INSTALLMNT_DATE | DATE | 7 | Y | Date of next installment | |
OPERATOR | VARCHAR2 | 825 | Y | Operator | Lastname, firstname and login for opeator generating the invoice |
OPERATOR_LOGIN | VARCHAR2 | 20 | N | Operator login | |
ORDER_CONTACT | VARCHAR2 | 831 | Y | Order contact | Contact name in format: "last name, first name (contact number)". No contact number if only beneficiary. |
ORDER_NUMBER | VARCHAR2 | 4000 | Y | Order Number | Order number |
ORGANIZATION | VARCHAR2 | 240 | N | Organization | Organization name |
PAID_AMT_ITX | NUMBER | 22 | Y | Amount of invoice already paid | |
PAYMENT_STATUS | VARCHAR2 | 4000 | Y | Payment state. Possible values are: - Paid - Not paid - Partially paid |
|
POS | VARCHAR2 | 32 | Y | Point of sales code | |
REMARK | VARCHAR2 | 4000 | Y | Remark | Remark for the group |
SALES_CHANNEL | VARCHAR2 | 240 | Y | Sales channel | Sales channel name |
SAL_ENT_COUNTRY_CODE | CHAR | 2 | Y | Sales entity country code | Country code of the selling entity |
SAL_ENT_ID | NUMBER | 22 | Y | Identifier of the sales entity | |
SAL_ENT_NAME | VARCHAR2 | 240 | Y | Sales entity name | Name of the sales entity |
SAL_ENT_STRUCT_ADDRESS | VARCHAR2 | 400 | Y | Mailing address of the contact structure | |
SAL_ENT_STRUCT_COUNTRY_CODE | CHAR | 2 | Y | Contact structure country code | |
SAL_ENT_STRUCT_ID | NUMBER | 22 | Y | Identifier of the contact structure | |
SAL_ENT_STRUCT_NAME | VARCHAR2 | 240 | Y | Sales entity structure | Contact structure name |
SAL_ENT_STRUCT_ZIP_CODE | VARCHAR2 | 20 | Y | Contact structure zip code | |
SHIPMENT_MODE | VARCHAR2 | 240 | Y | Shipment mode | Shipment mode name |
SHIPMENT_NUMBER | VARCHAR2 | 40 | Y | Technical identifier of shipment | |
SHIPMENT_STATE | VARCHAR2 | 4000 | Y | Shipment state | Shipment state. Possible values are: - Sent - Not sent - Cancelled - Reference - Reprocess |
STATE | VARCHAR2 | 4000 | Y | State | Invoice state (cancelled or not) |
TOTAL_OVERDUE_AMT | NUMBER | 22 | Y | Sum of overdue installments | |
TOTAL_OVERDUE_DAYS | NUMBER | 22 | Y | Total overdue days | Sum of overdue days. Example case: Invoice contains 2 installment payments. 1st installment -- overdue by 5 days 2nd installment -- overdue by 3 days In this case, value will be 8 |
T_CANCELLED_INVOICE_ID | NUMBER | 22 | Y | Technical identifier of invoice cancelled by current invoice | |
T_INVOBJECT_ID | NUMBER | 22 | Y | Technical identifier of the list of invoiced operations | |
T_INVOICE_ID | NUMBER | 22 | N | Technical identifier of invoice | |
T_KIND | VARCHAR2 | 11 | Y | Invoice type: - CREDIT_NOTE - INVOICE |
|
T_ORGANIZ_ID | NUMBER | 22 | N | Technical identifier of organization | |
T_PAYMENT_STATUS | VARCHAR2 | 14 | Y | Invoice payment state: - PAID - PARTIALLY_PAID - NOT_PAID |
|
T_POS_ID | NUMBER | 22 | Y | Technical identifier of point of sales | |
T_SALESCHANNEL_ID | NUMBER | 22 | Y | Technical identifier of sales channel | |
T_SALES_CHANNEL_TYPE | VARCHAR2 | 25 | Y | Type of sales channel | |
T_SHIPMENTMODE_ID | NUMBER | 22 | Y | Technical identifier of shipment mode | |
T_SHIPMENT_STATE | VARCHAR2 | 25 | Y | Shipment state. Possible values are: - UNSENT - SENT - CANCELLED - REFERENCE - REPROCESS |
|
T_STATE | VARCHAR2 | 13 | Y | Invoice state (cancelled or not) - CANCELLED - NOT_CANCELLED |
|
VAT_NUMBER | VARCHAR2 | 4000 | Y | VAT Registration Number printed on the invoice |