The layout at 10 March 2011
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