D_ACCOUNT_LIST_INVOICE

Version: 1.0

Attribute details

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 Y 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 400 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

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	Y		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	400	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