Seq | FIELD | Description | Format | Controlled Values | Possible Values | Comment |
1 | Company_id | Company | Yes | TEXT 10 | AX Company Code set up in S01 e.g. AU01 | |
2 | Journal_name | Journal name | Yes | TEXT 10 | 1INV (ITAS PI,SI,DN,CN), 1PMR(ITAS CP,CI) 1ACC(ITAS TA) 1INT(specific accounts) 1STK(specific stock accounts) | |
3 | Name_of_transaction | Name of transaction | no | TEXT 60 | Description of ITAS transactions e.g. Purchase Invoice | |
4 | Local_COA | General Account | Yes | TEXT 10 | Alternative Account as maintained in NOM (General Ledger). For AR/AP the accounts are the nominated control accounts or accounts linked to Expense Codes | |
5 | Local_COA_type | Account type | Yes | TEXT 20 | VENDOR (Supplier) CUSTOMER (Customer) LEDGER (all others) Accounts Lists exist as overrides for VENDOR and CUSTOMER | A |
6 | Counterparty_id | Counterparty ID | Yes | TEXT 20 | ITAs alternate code for Client on Transaction unless BROZZZZZZ or BUSZZZZZ | B |
7 | Bank_id | Bank id | no | TEXT 20 | Not used | |
8 | Currency | Transaction Currency | Yes | TEXT 3 | Transaction Currency Code | |
9 | DB_curr | Debit in transaction currency | no | NUM | Debit value if transaction is a debit (positive) | |
10 | CR_curr | Credit in transaction currency | no | NUM | Credit value if transaction is a credit (positive) | |
11 | VAT_AMT_CUR | VAT amount of the invoice | No | NUM | VAT amount if VAT code exists | L |
12 | DB_loc | Debit in local currency | no | NUM | Not used | D |
13 | CR_loc | Credit in local currency | no | NUM | Not used | D |
14 | DB_sec | Debit in secundary currency | no | NUM | Not used | E |
15 | CR_sec | Credit in secundary currency | no | NUM | Not used | E |
16 | FRONT_ID | Transaction ID in front system | no | TEXT 20 | ITAS Document Reference | H |
17 | Document | Document number | no | TEXT 20 | ITAS Document Reference | F |
18 | Invoice | Invoice number | no | TEXT 20 | Blank on Payments otherwise ITAS Document Reference | F |
19 | Payment_reference | Invoice to be settled | no | TEXT 20 | ITAS Secondary Reference on Payments | F |
20 | Transaction_date | Transaction date (booking date) | Yes | YYYYMMDD | Transaction Document Date | C |
21 | Value_date | Value date for bank transaction | no | YYYYMMDD | Transaction Value Date on Payments | |
22 | Document_date | Document issue date | no | YYYYMMDD | Exchange Rate Date in ITAS | C |
23 | Due_date | Invoice due date | no | YYYYMMDD | Transaction Value Date on Invoices | G |
24 | TAX_group | tax group | Yes | text 10 | ITAS Transaction VAT Code converted to alternate code in VAT (part before ‘/’) | |
25 | Item_TAX_group | item tax group | Yes | text 10 | ITAS Transaction VAT Code converted to alternate code in VAT (part after ‘/’) | |
26 | Spread_id | Spread codification for periodic allocation | Yes | text 10 | not used for trade front system | |
27 | Spread_start_date | Start date of the spread allocation | Yes | YYYYMMDD | not used for trade front system | |
28 | Extract Date | Date of extraction | no | YYYYMMDD | ITAS Date when interface file created | I |
29 | SBOX-1 | SBOX – 1 | Yes | TEXT 50 | Alternate code of Category linked to transaction Department | |
30 | CC-1 | COST CENTER -1 | Yes | TEXT 50 | Not used | |
31 | TOE-1 | TOE – 1 | Yes | TEXT 50 | Alternate Code for Transaction Expense Code | |
32 | FIMMO | FIMMO | Yes | TEXT 50 | not used for trade front system | |
33 | DIM5 | DIMENSION 5 | Yes | TEXT 50 | not used for trade front system | |
34 | DIM6 | DIMENSION 6 | Yes | TEXT 50 | not used for trade front system | |
35 | DIM7 | DIMENSION 7 | Yes | TEXT 50 | not used for trade front system | |
36 | DIM8 | DIMENSION 8 | Yes | TEXT 50 | not used for trade front system | |
37 | STATE | STATE | Yes | TEXT 50 | not used for trade front system | |
38 | BRANCH | BRANCH | Yes | TEXT 50 | not used for trade front system | |
39 | COUNTERPARTY | COUNTERPARTY | no | TEXT 20 | not used for trade front system | K |
40 | COUNTERPARTY TYPE | COUNTERPARTY TYPE | no | TEXT 20 | not used for trade front system | K |
41 | BANK | BANK | no | TEXT 50 | not used for trade front system | |
42 | PARTNER1 | PARTNER1 (EQUITY) | no | TEXT 50 | not used for trade front system | |
43 | COMMODITY | COMMODITY CODE | no | TEXT 50 | ITAS Commodity Code from Contract | |
44 | GRADE | GRADE | no | TEXT 50 | ITAS Commodity Code Part 3 from Contract | |
45 | DISCHARGE COUNTRY | DISCHARGE COUNTRY | no | TEXT 50 | Country taken from Destination Port on Contract | |
46 | DISCHARGE PORT | DISCHARGE PORT | no | TEXT 50 | Destination Port on Contract | |
47 | LOAD COUNTRY | LOAD COUNTRY | no | TEXT 50 | Country taken from Load Port on Contract | |
48 | LOAD PORT | LOAD PORT | no | TEXT 50 | Load Port on Contract | |
49 | SALES CONTRACT ID | SALES CONTRACT REFERENCE | no | TEXT 50 | Contract Number from Transaction if Sale (first 6 digits) | |
50 | SALES CONTRACT SECTION | SALES CONTRACT SECTION | no | TEXT 50 | Not Used | |
51 | SALES EXECUTION ID | EXECUTION SALES CONTRACT REFERENCE ID | no | TEXT 50 | Sale Contract Suffix | |
52 | PURCH CONTRACT ID | PURCHASE CONTRACT REFERENCE | no | TEXT 50 | Contract Number from Transaction if Purchase (first 6 digits) | |
53 | PURCH CONTRACT SECTION | PURCHASE CONTRACT SECTION | no | TEXT 50 | Not Used | |
54 | PURCH EXECUTION ID | EXECUTION PURCHASE CONTRACT REFERENCE ID | no | TEXT 50 | Purchase Contract Suffix | |
55 | MASTER QTY | QUANTITY (principal) | no | NUM | Quantity taken from Accounting Transaction | |
56 | MASTER UNIT | UNIT OF MEASURE (principal) | no | TEXT 50 | Accounting Transaction U/M | |
57 | UNIT PRICE | UNIT PRICE | no | TEXT 50 | Price calculations as value divided by units | |
58 | UNIT PRICE MTM | UNIT PRICE MTM | no | TEXT 50 | Valuation Price if entered on Contract | |
59 | SECOND QTY | QUANTITY (secondary) | no | NUM | Not Used | |
60 | SECOND UNIT | UNIT OF MEASURE (secondary) | no | TEXT 50 | Not Used | |
61 | VESSEL NAME | VESSEL NAME | no | TEXT 50 | Vessel name taken from Contract on Transaction | |
62 | BILL | BILL OF LADING (DATE) | no | YYYYMMDD | B/L date from Contract | |
63 | SHIPMENT | SHIPMENT | no | TEXT 50 | Shipment/Delivery Period from Contract | |
64 | INCOTERM | INCOTERM | no | TEXT 50 | INCO Terms from Contract | |
65 | INVOICE STATUS | INVOICE STATUS | no | TEXT 50 | Provisory, Final, Debit Note or Credit Note | |
66 | LOCATION | LOCATION | no | TEXT 50 | Not used | |
67 | ASSET REF | ASSET REFERENCE | no | TEXT 50 | Not used | |
68 | RIMMO | RIMMO | no | TEXT 50 | Not used | |
69 | PROJECT | PROJECT REFERENCE | no | TEXT 50 | Not used | |
70 | TRADER | TRADER | no | TEXT 50 | Not used | |
71 | EMPLOYEE | PEOPLE IDENTIFICATION | no | TEXT 50 | Not used | |
72 | PERIOD | SERVICE PERIOD | no | TEXT 50 | Not used | |
73 | FREE TEXT | EXPLANATION - FREE TEXT FIELD | no | TEXT 250 | Not used | |
74 | CON TAX | Concessionary Tax | no | TEXT 50 | Not used | |
75 | COST | Cost in front System | no | TEXT 50 | Not used | |
76 | FRONT INVOICE ID | Invoice ID in front system(s) | no | TEXT 50 | Not used | J |
77 | FRONT ACCRUAL ID | Accrual ID in front system(s) | no | TEXT 50 | Not used | J |
78 | FRONT PAYMENT ID | Payment ID in front system(s) | no | TEXT 50 | Not used | J |
79 | MATCH ID | Match ID to be uploaded | no | TEXT 50 | Not used | J |
80 | STAT 40 | STATISTICAL FIELD 40 | no | TEXT 50 | Not used | |
81 | STAT 41 | STATISTICAL FIELD 41 | no | TEXT 50 | Counterparty Reference on Contract | |
82 | STAT 42 | STATISTICAL FIELD 42 | no | TEXT 50 | Counterparty Reference on Invoice | |
83 | STAT 43 | STATISTICAL FIELD 43 | no | TEXT 50 | Not used | |
84 | STAT 44 | STATISTICAL FIELD 44 | no | TEXT 50 | Not used | |
85 | STAT 45 | STATISTICAL FIELD 45 | no | TEXT 50 | Not used | |
86 | STAT 46 | STATISTICAL FIELD 46 | no | NUM | Not used | |
87 | STAT 47 | STATISTICAL FIELD 47 | no | NUM | Not used | |
88 | STAT 48 | STATISTICAL FIELD 48 | no | NUM | Not used | |
89 | STAT 49 | STATISTICAL FIELD 49 | no | NUM | Not used | |
90 | STAT 50 | STATISTICAL FIELD 50 | no | NUM | Not used | |
91 | STAT 51 | STATISTICAL FIELD 51 | no | YYYYMMDD | Not used | |
92 | STAT 52 | STATISTICAL FIELD 52 | no | YYYYMMDD | Not used | |
93 | STAT 53 | STATISTICAL FIELD 53 | no | YYYYMMDD | Not used | |
94 | STAT 54 | STATISTICAL FIELD 54 | no | YYYYMMDD | Not used | |
95 | STAT 55 | STATISTICAL FIELD 55 | no | YYYYMMDD | Not used | |