What is CLI

ITAS maintains all of its' 3rd Party accounts in CLI i.e. customers, suppliers, service companies, banks, brokers, agents, shipping lines, hauliers, warehouses... These can be maintained singularly, Bulk Edit feature or Import processes.

CLI is the maintenance program that also handles various reporting, enquiries and TRADE/Expedite processes. All account creation and amendment is performed in CLI, this includes account renaming, deletion, and temporary freeze of the account to restrict access for ledger postings etc. All strategic maintenance tasks are tightly controlled by further security/privilege procedures that are maintained in gf/CMP. The Expedite processes are controlled at company level by use of ctrl02_spotstock (Hivedome activated feature).

 

If an ITAS company is operating several legal entity companies on the same ITAS server, there are procedures for Shared Data. This enables a tighter control of what codes can be maintained on the associate companies whereby ONE ITAS entity is nominated as the Master and many associates can be linked thereafter.

 

There are some simple import processes that can be activated from the front screen by mouse right-click. The import process file is a .csv with explicit columns (see detail below) for the data that ITAS will handle on import. The mandatory columns on the Import Main are the account reference and account name.  The Import Main can also be used as an amendment process i.e. account reference column completed and any other columns will update accordingly.  The sub imports i.e. Contacts, Banks, Warehouses are tab delimited file types.

 

The Client Ledger is used to group Bought and Sales accounts (Open Item style) and Treasury/FX and F&O Trading accounts (balances carried/forward).
The program displays a form with tabs that define the account profile (account reference, type, address, limits...), that show balances, transactions, risk etc. The report button on the tool bar provides several styles, e.g Forms, print labels, Mailmerge, list account balances, show 'introductory broker' content and access to the ReportWriter.  The label print will allow specification of own label sizes/numbers on a sheet.

 

The single most important information held in CLI is the Account Reference. A unique identifier that represents the account throughout ITAS. The Account Reference also classifies the account as a Bought ledger (extension .P), Sales ledger (extension .S) or a Trading (FX,F&O,SHARE) account (extension .T). Another important code is the account code that describes the companies main operation e.g. Shipping Company, Warehouse, Bank/broker, Haulier, Agent.

 

Due to their volatility and the amount of information related to the accounts held in CLI, it is convenient to view/ maintain them separate from the Nominal/ General Ledger. The operation of these accounts is identical to the way they would be managed in the Nominal/ General Ledger. Bought and Sales Ledger accounts are open item and therefore archiving occurs only upon completion of cash matching.

 

Trading accounts operate with balance carry forward (C/F) and Brought Forward (B/F) as they would if they resided as accounts in the balance sheet. Trading accounts are used where the posting of transactions is extensive (i.e. futures/ option settlements). Due to this business practice, these accounts are not operated on a strict cash matching basis but there is a feature for match/marking these accounts transactions using MATT.

 

The CLI features are: -
  • Account maintenance; creation (CMP privilege controlled), deletion (CMP privilege), freeze status, renaming.
  • Bulk edit of specific CLI data that is more easily edited in a grid form.
  • Account limits maintenance, used for credit control and risk analysis. (CMP privilege controlled)
  • View balances and drill down for transactional analysis, also can view documents not authorised and not posted.
  • View details of associate family members.
  • View TRADE (contract) details, extensive filtering options are available. The standard process is to locate the TRADE records for the counter-party BUT in the situation where a CLI account is also ticked as an Association/Co-op type additional search/display will show the association purchase/sale TRADE records.
  • Reports;Report Writer activation with some standard Hivedome generated listing forms provided for static account lists.
    Produce Name & Address labels. By using the output to Text File with tab delimiters, you can produce a file for Mail Merge. When the text file has been produced, open a word document and activate tools to access the Word/Mail merge process.  It will walk you through the steps required with the result of a single file with a page for each account selected.  If this file is placed in a corporate directory that is accessible by DOCMAN you can then include that entire file into the DOCMAN indexing subsystem.
  • List Client Balances.
  • List the various Commission rates e.g. F&O, CFD, FX.
  • List Warehouse oriented data ex. the View/Warehouse sub-forms.
  • Credit rating report, can view any imported Risk report from D&B, S&P etc. The files must reside in itas/Dun&Brad sub directory and be named as the A/c reference (without the .P)
  • List of Introductory brokers and their accounts with some account detail.
  • List inventory (Ferrous style, Cotton style and others) for a warehouse code. Activated when the account is ticked as a warehouse type.
  • Forms creation, needs company folder Clientdocs. The DOCDES forms need to be correctly parsed before use in CLI.  See Chase letter for example of how to use this feature.
  • Ratings, lists the accounts that are setup with ratings data e.g. Product,  Regulatory compliance…
  • Performance for open-item style account (i.e. P or S type)Risk summary, similar in concept/design as CPRISK but illustrating a different form of forward commitment.  Drill-down is enabled to view details.
  • Payment history of SI/DN transactions.
  • Sales turnover; reports the account's INVOICED history organised by accounting period allowing you to use the charts feature for pictorial presentation after viewing the results. There are options for viewing by product or by period.
  • Purchase TRADED tonnage analysis, with charting after viewing. $ accumulated only operates for priced TRADEs.  There are options for viewing by product or by period. The purchase turnover can also be viewed from WIPLIST/style 5.
  • Credit Application Form is a fixed form with various details for Management to review and agree revised limits.
  • Insurance Claims History. TRADE/Traffic can be used to maintain some claim details (phys20) which can be viewed by this process.
  • Account Sales Performance;  produces a 3 part view (Open TRADE records i.e. Sales not allocated , Nominated i.e. Sales allocated and NOT invoiced and the Other section is Sales allocated and Invoiced). This includes an analysis of Invoice performance.
  • Accounting Performance: Accounting transactions posted to the CLI ledger are analysed to their accounting period cell with the option of showing only Cash transactions (CI/CP) or non-Cash. This is an useful review of supplier costs but there is no exclusion of reviewing any of SI, JL,CN  etc.  After view, can chart by various standard features e.g. 2D, 2bar.
  • Equity/Performance for Trading style accounts (.i.e. T type) Combined Statement, EQUITY style report for ‘call situation’ for any trading account, includes F&O, FX, SHARE. Drill-downs are enabled on selected columns. Unposted Commissions can be included (CLI static option).
  • Net Equity, similar in layout as ‘Combined Statement’ but shows the detail analysis for F&O only.
  • Client recap, detail review of F&O and CFD positions with some monetary illustrations.
  • Spot Deliveries processes {ctrl02_spotstock=Y}, spot stock is a part of CLI/Deliveries.  The Spot tab enables selections to create a picking list of stock items.  A Spot Delivery/Call-off list can be entered, amended and deleted. This feature only uses Purchase stock records that are setup as ‘spot’.  The process creates TRADE records using a template Spot Sales TRADE (S01 setup and MEPACT) and a ‘piece-of-paper’ with instructions to the factory for picking/manufacturing.  These procedures complement the TRADE/Call-off process.
  • Call-off/Deliveries from TRADE Sales. The Delivery/Call-off details can be entered or deleted. This feature only uses Sales TRADEs that are setup for the counter-party and have un-invoiced tonnage.  This creates splits from the TRADE records and a ‘piece-of-paper’ with instructions to the factory for picking/manufacturing. The Delivery Note can also be produced as a XML form.  These procedures integrate with the TRADE/Call-off process, which can also be used to amend the delivery instructions
  • Several specialised maintenance features are available from the View icon, these include:-Details for Integrated Interest reporting (INTREP)
  • Forex (FX) trading static information
  • list of Contacts, with their individual communications
  • list of Bank Account Details
  • Warehouse data (when account has warehouse ticked). Can maintain tariffs, location of sheds and some descriptions.
  • viewing CLI costs matrix (if SSU has setup for company to operate client oriented costs in TRADE),
  • CLI specific premiums (TRADE special feature),
  • list of preferred products (used in CLI/Delivery-calloff for Spot sales and e-ITAS sales Order)
  • list of factories, used in TRADE/Expedite to assist in which factory is best situated to source the sale
  • list of DOCDES Templates, used by INVOICING and TRADE to suggest the list of forms that need to be created for each TRADE delivery/invoice situation
  • Enterprise (CRM) data. This can be used to describe the profile of consumers e.g. farmers in more detail so that Sales personnel have some easily accessed marketing information
  • Instructions, maintenance of text for describing this customers specific requirements for delivery etc e.g. Labeling, pallets, packing, delivery times.  These text can be easily included in DOCDES rules for forms creation.
  • Family Limits, maintenance of the credit limits, when the account being viewed is the nominated Head-Of-Family.  These limits are used by TRADE checking and CPRISK. This feature is activated by special S01 feature.
  • Haulage rates (when account has Haulier ticked). Can maintain rates and some basic descriptions.
  • Documents Flow,  list of codes that represent forms sent to counterparty and recording of sent/returned.
  • Department limits, maintenance of the credit limits.  These limits are used by TRADE checking and CPRISK.
  • Ratings, maintenance  of codes that indicate compliance e.g. Product,  Regulatory …
  • Payment overrides,  list of  days of the month for the payment override e.g. 10th, 20th and 30th whereby this account only operates their book-keeping/payment runs on those days in the month.
  • Credit References, list of account references (CLI) to whom a Credit Ref document may be sent
  • VAT Registration, list of additional VAT Registration Numbers, used in PINV/SINV DOCDES rule.
  • Alternative Languages, Account Name and Address details can be maintained in another e.g. Chinese characters. Useful for DOCDES presentation. Needs a company _codetrans table to be activated, so Hivedome intervention needed.
  • Sustainability Compliance, when a CLI profile is nominated as a Mill/Gin a form for various Compliance data is enabled e.g. Audit dates, PROTERRA, SEDEX, FAIRTRADE specific fields. Note there are some simple data maintenance on the Co. Numbers page of CLI
  • Enable an account to access the Operating company web-site. See CLI/Miscellaneous where the different browser features can be enabled for the account e.g. Sales Order, Shipping Status report
  • View details of SHAREs that have been traded by the account, mouse right-click or Ctrl H shortcut
  • View details of TRS/FX+L&D+BONDS deals that have been traded by the account, mouse right-click or Ctrl T shortcut
Forms /Credit References (right-click option prior to entry of any A/c Ref). Feature to produce standard DOCDES letters for immediate despatch by email.

 

ITAS Client Account Import (right-click option prior to entry of any A/c Ref - Import/Import Main)
Import is a .csv or .txt file with FIXED columns/ fields, all optional except Account reference and account name. Import can be used for new Account Referenece or Update of existing accounts.

Every row is a data update i.e. there are no headings etc. 

Field No

Col Name

Name

Description

Mandatory

Chr20 field

1

A

Account Reference

3 – 8 characters, optional .P or .S

Yes

chr20_acc

2

B

Name/Title

Max 60 Chars

Yes

chr20_title

3

C

Address Line 1

Max 60 Chars

 

chr20_addr1

4

D

Address Line 2

Max 60 Chars

 

chr20_addr2

5

E

Address Line 3

Max 60 Chars

 

chr20_addr3

6

F

Address Line 4

Max 60 Chars

 

chr20_addr4

7

G

Zip Code

Max 40 Chars

 

chr20_zipcode

8

H

Email Address

Max 100 Chars

 

chr20_emailaddr

9

I

Fax No.

Max 40 Chars

 

chr20_faxno

10

J

Telephone No.

Max 40 Chars

 

chr20_phoneno

11

K

Account Type

Valid ITAS Account Type Code (CLICODES)

 

chr20_type

12

L

Buyer

Y to tick

 

chr20_canbeabuyer

13

M

Seller

Y to tick

 

chr20_canbeaseller

14

N

Shipping Co.

Y to tick

 

chr20_canbeashipper

15

O

Warehouse

Y to tick

 

chr20_canbeawarehouse

16

P

Agent

Y to tick

 

chr20_canbeaagent

17

Q

Delivery Account

Y to tick

 

chr20_canbeadelclient

18

R

Third Party

Y to tick

 

chr20_canbea3rdparty

19

S

Bank

Y to tick

 

chr20_canbeabank

20

T

Service Provider

Y to tick

 

chr20_canbeaservice

21

U

Country

Valid ITAS Country Code / will use company default if invalid (COUNTRIES)

 

chr20_geogcd

22

V

Region

Valid ITAS Region (CLICODES)

 

chr20_region

23

W

Grid Ref

Valid ITAS Grid Ref/County (CLICODES)

 

chr20_gridref

24

X

Province

Valid ITAS Province/State (CLICODES)

 

chr20_province

25

Y

Group Account

Y to tick

 

chr20_group

26

Z

Department code

Valid ITAS code (DEPT)

 

chr20_dept

27

AA

A/c manager

Valid ITAS code (CMP/user )

 

chr20_trinit

28

AB

Other Classification

Valid ITAS code (CLICODES)

 

chr20_othcd

29

AC

VAT Code

Valid ITAS code (VAT)

 

chr20_vatcode

30

AD

VAT Reg. No.

Max 16 characters

 

chr20_vatreg

31

AE

Fiscal Reg. No

Max 18 characters

 

chr20_fiscalreg

32

AF

FLO-ID

Max 40 characters

 

chr20_telexno

33

AG

Payment Code

Valid ITAS code(PHYSCODES/Payment)

 

chr20_paycode

34

AH

Payment Limit

Numeric with max 2 decimal places

 

chr20_paylimit

35

AI

Commitment Limit

Numeric with max 2 decimal places

 

chr20_fwdlimit

36

AJ

Payment Instruction

Valid ITAS code (TEXT with Group=’PAYINSTR’)

 

chr20_payinstr

37

AK

Insurance limit date

YYYYMMDD

 

chr20_inslimitdate

38

AL

Default language

Valid ITAS Country code (COUNTRIES)

 

chr20_docdesctry

39

AM

Haulier

Y to tick

 

chr20_canbeahaulier

40

AN

Alternate Name

Max 60 characters

 

chr20_invtitle

41

AO

Alternate Address1

Max 60 characters

 

chr20_invaddr1

42

AP

Alternate Address2

Max 60 characters

 

chr20_invaddr2

43

AQ

Alternate Address3

Max 60 characters

 

chr20_invaddr3

44

AR

Head Of family

CLI account that MUST exist before can import

 

chr20_headcl

45

AS

Can be a Gin / Mill

Y to tick

 

chr20_canbeamill

46

AT

Purchase Growth

Valid ITAS Growth Code ( PHYSCODES)

 

chr20_purchasegrowth

47

AU

Certificated Growth

Valid ITAS Growth Code ( PHYSCODES)

 

chr20_cerificatedgrowth

48

AV

Can be a Controller

Y to tick

 

chr20_canbeacontroller

49

AW

C2C Reference

Max 50 characters

 

chr20_ediaddr

50

AX

Swift Address

Max 50 characters

 

chr20_swiftaddr

51

AY

Haulage Rate

Max 2 decimal places

 

chr20_haulrate

52

AZ

Associate

Companies

List of associate companies to also update when importing into a master company. Associate company list must be separated by a full stop. i.e. ‘ly.lt.lz’

 

 

53

BA

Holder ID

Max 10 Characters

 

chr20_holderid

54

BB

Can be a grower

Y to tick

 

chr20_canbeagrower

55

BC

CP Risk Category

1, 2, 3, 4, 5 or 6

 

chr20_cpriskcategory

56

BD

External Ref

Max 20 characters

 

chr20_externalref

57

BE

Add Type

Valid ITAS Account Type Code (CLICODES)

 

chr20_type2

58

BF

Short Name

Max 100 characters

 

chr20_shortname

59

BG

Can be an association

Y to tick

 

chr20_canbeassociation

60

BH

Can be a grower

Y to tick

 

chr20_canbeagrower

61

BI

Can be a private person

Y to tick

 

chr20_canbeaprivateperson

62

BJ

City tax code

Max 18 characters

 

chr20_citytaxcode

63

BK

Memo

Max 4000 characters

 

chr20_memo

64

BL

Fethab applies

Y to tick

 

chr20_fethab

65

BM

Client has a court order

Y to tick

 

chr20_courtorder

66

BN

Court order start date

YYYYMMDD format

 

chr20_courtorderst

67

BO

Court order end date

YYYYMMDD format

 

chr20_courtorderen

68

BP

House No

Max 60 characters

 

chr20_houseno

69

BQ

City

Valid city code (CLICODES)

 

chr20_city

70

BR

Operations Initials

Valid Initials

 

chr20_opscmp

71

BS

Finance Initials

Valid Initials

 

chr20_fincmp

72

BT

Short Code

Unique Code, 3 or 6 characters

 

chr20_shortcode

73

BU

Payment Mode

Valid CLICODES/Pay mode (cmy241)

 

chr20_paymode

74

BV

Embargo

Y to tick

 

chr20_embargo

75

BW

Style

Valid CLICODES/Styles (cmy129)

 

chr20_style

76

BX

Insurance Limit Ccy

Valid Currency Code

 

chr20_inslimitccy

77

BY

Temporary Insurance Limit Ccy

Valid Currency Code

 

chr20_inslimitccy

78

BZ

Insurance Limit

Numeric with max 2 decimal places

 

Chr20_inslimit

79

CA

Temporary Insurance Limit

Numeric with max 2 decimal places

 

Chr20_pinslimit

80

CB

Temporary Insurance Limit Expiry Date

YYYYMMDD format

 

Chr20_pinslimitdate

81

CC

Insurance Limit Start Date

YYYYMMDD format

  

chr20_inslimitstart

82

CD

 Insurance Company

Valid Client account marked as a service provider

  

chr20_insco

83

CE

Priced Limit (Tonnes)

Numeric with max 2 decimal places

  

chr20_pricedmtlimit

84

 CF Unpriced Limit (Tonnes) Numeric with max 2 decimal places  

chr20_unpricedmtlimit

85

 CG Total Limit (Tonnes) Numeric with max 2 decimal places  

chr20_totalmtlimit

86

 CH Forward Tradeable Numeric with max 2 decimal places   chr20_fwdmonthslimit

87

 CI Spot/Market Limit Numeric with max 2 decimal places   chr20_spotlimit

88

 CJ Market Default Risk Numeric with max 2 decimal places   chr20_mktdefrisklimit 

89

 CK Pre Financing Limit Numeric with max 2 decimal places   chr20_preexportlimit 

90

 CL Collections Limit Numeric with max 2 decimal places   chr20_bondgteelimit

91

 CM Credits Limit  Numeric with max 2 decimal places   chr20_creditslimit
92 CN Stocks Limit Numeric with max 2 decimal places  

chr20_stockslimit 
93 CO Investments Limit Numeric with max 2 decimal places  

chr20_investlimit 

 

Bank Account details, tab delimited. Mandatory fields are CLI Account and Bank Name
Row 1, cell 1 must have content chr23
Row 2 columns are the database table names without the leading chr23_ e.g. acc, name
All columns are optional except those marked as mandatory.

 

Field
  
Name
Description
Mandatory
Chr23 field
1
  
Account
Valid Client Account
Yes
chr23_acc
2
  
Bank's Account no.
Free Format. Max characters 34
  
chr23_accnum
3
  
Bank Name
Free Format. Max 40 characters. Cannot already exist for this account acc
Yes
chr23_name
4
  
Bank's Address line 1
Free Format. Max 40 characters
  
chr23_address1
5
  
Bank's Address line 2
Free Format. Max 40 characters
  
chr23_address2
6
  
Bank's Residence
Free Format. Max 40 characters
  
chr23_res
7
  
Bank's Zip code
Free Format. Max 10
  
chr23_zip
8
  
Bank's Boec country code
Valid ITAS Country Code
  
chr23_country
9
  
Bank's Swift address
Free Format. Max 50 characters
  
chr23_swift
10
  
Bank's Phone no.
Free Format. Max 20 characters
  
chr23_phonenum
11
  
Bank's Telex no.
Free Format. Max 20 characters
  
chr23_telexnum
12
  
Bank's Telex answer
Free Format. Max 20 characters
  
chr23_telexansw
13
  
Bank's Fax number
Free Format. Max 20 characters
  
chr23_faxnum
14
  
Default bank for client
Y/N
  
chr23_default
15
  
Bank's Bank number
Numeric. Max 6 digits
  
chr23_bankno
16
  
Bank's Branch number
Numeric. Max 6 digits
  
chr23_bankbranch
17
  
Correspondent Bank Name
Free Format. Max 40 characters
  
chr23_correspname
18
  
Correspondent Bank Address
Free Format. Max 40 characters
  
chr23_correspaddr
19
  
Correspondent Bank's Swift address
Free Format. Max 50 characters
  
chr23_correspswift
20
  
Ccy code
Valid ITAS Currency Code
  
chr23_ccy
21
  
FED ABA
Numeric. Max 9 digits
  
chr23_fedaba
22
  
Chips
Numeric. Max 6 digits
  
chr23_chips
23
  
Correspondent  Boec country code
Valid ITAS Country Code
  
chr23_correspcountry
24
  
Correspondent Account no.
Free Format. Max characters 34
  
chr23_correspaccnum
25
  
Correspondent Bank number
Numeric. Max 6 digits
  
chr23_correspbankno
26
  
Correspondent Branch number
Numeric. Max 6 digits
  
chr23_correspbankbranch
27
  
Correspondent FED ABA
Numeric. Max 9 digits
  
chr23_correspfedaba
28
  
Correspondent Chips
Numeric. Max 6 digits
  
chr23_correspchips
29
  
Client code of bank, links in the Pagos/Sebra bank interfaces
Valid Open Client Account where Account type =  Bank
  
chr23_clicode
30
  
ID type 1 to 8, R or N for Pagos/Sebra bank interfaces.
1,2,3,4,5,6,7,8,R,N
  
chr23_Idtype
31
  
Account type 0 or 1 for Pagos/Sebra bank interfaces.
0 or 1
  
chr23_acctype
32
  
VAT registration no. (NIT)
Free Format. Max 16 characters
  
chr23_vatreg
33
  
Unique Bank ID
Numeric. Latest must be maintained in ctrl10_nextbankid
  
chr23_bankid
34
  
External Ref
Max 35 characters
  
chr23_externalref
35
  
Intermediate Swift
Free Format. Max 50 characters
  
chr23_finalswift
36
  
Intermediate Bank Name
Free Format. Max 40 characters
  
chr23_finalcorrespname
37
  
Intermediate Bank Address
Free Format. Max 40 characters
  
chr23_finalcorrespaddr
38
  
Intermediate Bank Country
Valid ITAS Country Code
  
chr23_finalcorrespcountry
39
  
Digit
Max 18 characters
  
Chr23_digit
40
 
Clabe Reference
Max 18 characters
  
chr23_clabe
41
  
IBAN Ref
Max 34 characters
  
chr23_iban


Contact Details, tab delimited Mandatory fields are CLI Account and Contact Name
Row 1, cell 1 must have content chr24
Row 2 columns are the database table names without the leading chr24_ e.g. acc, name
All columns are optional except those marked as mandatory.

 

Field
 
Name
Description
Mandatory
Chr24 field
1
  
Account
Valid Client Account
Yes
chr24_acc
2
  
Contact's name
Free Format. Max characters 40. Cannot already exist for this client
Yes
chr24_name
3
  
Department
Valid ITAS Department
  
chr24_dept
4
  
Coded job role
Valid CLICODES>Job Role
  
chr24_jobrole
5
  
Contact's phone no.
Free Format. Max 20 characters
  
chr24_phonenum
6
  
Contact's telex no.
Free Format. Max 20 characters
  
chr24_telexnum
7
  
Contact's telex answer bank
Free Format. Max 20 characters
  
chr24_telexansw
8
  
Contact's fax number
Free Format. Max 20 characters
  
chr24_faxnum
9
  
Contact's Car phone no.
Free Format. Max 20 characters
  
chr24_carphone
10
  
Contact's Private phone no.
Free Format. Max 20 characters
  
chr24_privphone
11
  
Xmas Card
Y/N
  
chr24_xmascard
12
  
Number market report
Free Format. Max 1 character
  
chr24_nummktrep
13
  
Contact's hobby
Free Format. Max 40 characters
  
chr24_hobby
14
  
last visit Date
YYYYMMDD
  
chr24_lastvisit
15
  
New Contact date
YYYYMMDD
  
chr24_newcontact
16
  
Contact frequency (weeks)
Numeric. Less than 32768
  
chr24_contactfreq
17
  
Get market report
Y,P,N
  
chr24_mktrep
18
  
Contact's address line 1
Free Format. Max 40 characters
  
chr24_address1
19
  
Contact's address line 2
Free Format. Max 40 characters
  
chr24_address2
20
  
Contact's Residence
Free Format. Max 40 characters
  
chr24_res
21
  
Contact's zip code
Free Format. Max 40 characters
  
chr24_zip
22
  
Contact's country code
Valid ITAS Country Code
  
chr24_country
23
  
Title e.g. Mr.
Free Format. Max 10
  
chr24_title
24
  
Last name
Free Format. Max 40 characters
  
chr24_surname
25
  
First name
Free Format. Max 40 characters
  
chr24_firstname
26
  
Extra initial(s)
Free Format. Max 10
  
chr24_initial
27
  
Date of Birth
YYYYMMDD
  
chr24_dob
28
  
Email address
Free Format. Max 100 characters
  
chr24_emailaddr
29
  
‘P'rint, 'F'ax or 'E'mail to receive daily documentation (CLIDOC
P,F,E,A,B,W
  
chr24_clidocsmedia
30
  
prv40_username
 
  
chr24_cmpaccount
31
  
Contact's address line 3
Free Format. Max 40 characters
  
chr24_address3
32
  
ISDA Date
YYYYMMDD
  
chr24_Isdadate
33
  
Province Code
Brazil domestic - CLICODES/Province code
  
chr24_province
34
  
City Code
Brazil domestic - CLICODES/City code
  
chr24_city
35
  
State Tax Code
Brazil domestic - free formnat max 18
  
chr24_statetaxcode
Warehouse Details, tab delimited Mandatory fields is Account
Row 1, cell 1 must have content chr32
Row 2 columns are the database table names without the leading chr32_ e.g. acc, ownership
All columns are optional except those marked as mandatory.

 

Field
 
Name
Description
Mandatory
Chr32 field
1
 
Account
Valid Client Account. Account Type = Warehouse
Yes
chr32_acc
2
  
Ownership code 'O'wned or 'L'eased
O or L
  
chr32_ownership
3
  
Measure code e.g. CC or SQFT
Free Format. Max 4 characters
  
chr32_measurecode
4
  
Measure (floor space)
Numeric. Max 6 digits
  
chr32_measure
5
  
Capacity Code e.g. MT
Free Format. Max 4 characters
  
chr32_capacitycode
6
  
Warehouse capacity
Numeric. Max 6 digits
  
chr32_capacity
7
  
Y if operator liability insured
Y/N
  
chr32_opliabinsured
8
  
Cli alias of insurance underwriter
Valid Open Client Account. Not Control Account
  
chr32_compcoverage
9
  
Last inspection date
YYYYMMDD
  
chr32_lastinspectdt
10
  
Last inspected by
Free Format. Max 20 characters
  
chr32_lastinspectby
11
  
Last audit of good in warehouse
YYYYMMDD
  
chr32_lastauditdt
12
  
how often warehouse is inspected (days)
Numeric. Max 4 digits
  
chr32_inspectfreq
13
  
Number of rent free days for goods in warehouse
Numeric. Max 4 digits
  
chr32_rentfree
14
  
rent applied 'D'aily, 'M'onthly, 'P'art monthly
D or M or P
  
chr32_rentapply
15
  
performance code A-Z
A-Z
  
chr32_perfcode
16
  
Days out (days before task can be actioned)
Numeric. Max 4 digits
  
chr32_daysout
17
  
when days out last updated
YYYYMMDD
  
chr32_daysoutdt
18
  
preferred routing
Free Format. Max 8
  
chr32_prefroute
19
  
Early Shipment Provision
Y/N
  
chr32_esp
20
  
no. of days before shipment required for actual receipts
Numeric. Max 4 digits
  
chr32_espdays
21
  
TCA rules (texas,oklahoma,kansas) add 5-21 days of storage credit
Numeric. Max 4 digits
  
chr32_tcadays
22
  
Minimum days charged for if daily storage rate
Numeric. Max 4 digits
  
chr32_mindays
23
  
Currency for warehouse Tariff
Valid ITAS Currency Code
  
chr32_tariffccy
24
  
'R' or 'P' for per pack unit
R or P
  
chr32_tariffratetype
25
  
Tariff price code
ITAS Price Code.
  
chr32_tariffpcode
26
  
Tariff pack code if per pack
ITAS Pack Code. {cmy23_packcode}
  
chr32_tariffpackcode
27
  
USDA Compliant
Y/N
  
chr32_usda
28
  
CLI Account for Warehouse Provider
Valid Client Account. Account Type = Service. Not .T (F&O Trading Account)
  
chr32_provider
29
  
Which location for provider - Cordova,Fresno
Valid Location for Provider
  
chr32_location
30
  
Associated customer a/c
Free Format. Max 10
  
chr32_sampcustacc
31
  
Terminal where warehouse is located
Valid ITAS Terminal Code
  
chr32_terminal
32
  
CIT warehouse (Cotton in Transit) flag
Y/N
  
chr32_cit
33
  
CIT warehouse operates split CIT billing (loadout and receiving up front, storage at end)
Y/N
  
chr32_citbilling
34
  
Shipping Order doc required at Export time (Cotton)
Y/N
  
chr32_so
35
  
Bill of Lading doc required at Export time (Cotton)
Y/N
  
chr32_bl
36
  
Warehouse Fax doc required at Export time (Cotton)
Y/N
  
chr32_wf
37
  
Number of copies of Shipping Order Doc to be printed (a99)
Numeric. Max 2 digits
  
chr32_socopies
38
  
Number of copies of Bill of Lading Doc to be printed (a99)
Numeric. Max 2 digits
  
chr32_blcopies
39
  
Number of copies of Warehouse Fax Doc to be printed (a99)
Numeric. Max 2 digits
  
chr32_wfcopies
40
  
Location Port
Valid ITAS Port code
  
chr32_port
41
  
'P' for Tariffs by Provider else by Type (CCC,CERT)
P or T
  
chr32_tarifftype
42
  
If set (Y) then cotton does not change title automatically when in this warehouse
Y/N
  
chr32_notitle

 

Warehouse Tariff Details, tab delimited Mandatory fields are Account, Type and Effective Date.
Row 1, cell 1 must have content chr35
Row 2 columns are the database table names without the leading chr32_ e.g. acc, type
All columns are optional except those marked as mandatory.

 

Field No
Col Name
Name
Description
Mandatory
Chr35 field
1
A
Account e.g. 123456.P
Valid Client Account. Account Type = Warehouse.
Yes
chr35_acc
2
B
CCC, PUB, CERT, SPEC or can be Provider (CLI account)
Can be provider(CLI Account) only when Warehouse Tariff style(ctrl35_waretariff) = ‘P’ or when Warehouse Tariff style = ‘ ’ and Tariff Level(chr32_tarifftype) = ‘P’.
Yes
chr35_type
3
C
Date rates become effective
YYYYMMDD
Yes
chr35_effectivedate
4
D
‘H' for history
‘H’ for history (so not current tariff)
  
chr35_code
5
E
Storage rate
Numeric. Max 4 digits.
  
chr35_storage
6
F
Shipping/loadout for truck
Numeric. Max 4 digits.
  
chr35_loadtruck
7
G
Shipping/loadout for rail
Numeric. Max 4 digits.
  
chr35_loadrail
8
H
Compression
Numeric. Max 4 digits.
  
chr35_compression
9
I
Reweighing
Numeric. Max 4 digits.
  
chr35_reweigh
10
J
Resampling
Numeric. Max 4 digits.
  
chr35_resample
11
K
Cancellation of shipping order
Numeric. Max 4 digits.
  
chr35_cancelso
12
L
Marking
Numeric. Max 4 digits.
  
chr35_marking
13
M
Late pickup
Numeric. Max 4 digits.
  
chr35_latepickup
14
N
Drayage
Numeric. Max 4 digits.
  
chr35_drayage
15
O
Covering sample holes
Numeric. Max 4 digits.
  
chr35_csh
16
P
Insurance
Numeric. Max 4 digits.
  
chr35_insurance
17
Q
Consolidation
Numeric. Max 4 digits.
  
chr35_consolidation
18
R
Sample sacks
Numeric. Max 4 digits.
  
chr35_samplesacks
19
S
Special tags
Numeric. Max 4 digits.
  
chr35_specialtags
20
T
Additional marks
Numeric. Max 4 digits.
  
chr35_addmarks
21
U
Blocking
Numeric. Max 4 digits.
  
chr35_blocking
22
V
Receiving charge
Numeric. Max 4 digits.
  
chr35_receiving
23
W
Classing charge
Numeric. Max 4 digits.
  
chr35_classing
24
X
Early shipping order
Numeric. Max 4 digits.
  
chr35_eso
25
Y
Rent applied 'D'aily, 'M'onthly, 'P'art monthly
‘M’onthly, ‘D’aily, ‘P’ for Calendar months, ‘A’ for Anniversary, ‘B’ for Anniversary + 1
  
chr35_rentapply
26
Z
2nd storage rate
Numeric. Max 4 digits.
  
chr35_storage2
27
AA
3rd storage rate
Numeric. Max 4 digits.
  
chr35_storage3
28
AB
4th storage rate
Numeric. Max 4 digits.
  
chr35_storage4
29
AC
No. of days storage rate applies (0 = always)
Valid Integer.
  
chr35_storagedays
30
AD
No. of days storage rate applies (0 = always)
Valid Integer.
  
chr35_storagedays2
31
AE
No. of days storage rate applies (0 = always)
Valid Integer.
  
chr35_storagedays3
32
AF
No. of days storage rate applies (0 = always)
Valid Integer.
  
chr35_storagedays4
33
AG
Minimum storage
Numeric. Max 4 digits.
  
chr35_minstorage
34
AH
Y' if rates used in Loan details (redeem)
‘Y’ or ‘ ‘. Max one per Warehouse
  
chr35_loan
35
AI
2nd insurance rate
Numeric. Max 4 digits.
  
chr35_insurance2
36
AJ
3rd insurance rate
Numeric. Max 4 digits.
  
chr35_insurance3
37
AK
No. of months insurance rate applies (0 = always)
Valid Integer.
  
chr35_insurancemonths
38
AL
No. of months insurance rate applies (0 = always)
Valid Integer.
  
chr35_insurancemonths2
39
AM
No. of months insurance rate applies (0 = always)
Valid Integer.
  
chr35_insurancemonths3
40
AN
Number of rent free days for goods in warehouse. Can be by warehouse or tariff
Numeric. Max 4 digits.
  
chr35_rentfree
41
AO
Storage Price Code if different from warehouse
Valid Price Code or ‘BALE’
  
chr35_storagepcode
42
AP
Set to 'A' if receiving amount paid on inbound
‘A’ or ‘ ‘
  
chr35_receiveflag
43
AQ
Set to 'A' if loading amount paid on inbound
‘A’ or ‘ ‘
  
chr35_loadflag
44
AR
Stacking charge
Numeric. Max 4 digits.
  
chr35_stacking
45
AS
Stacking Price Code if different from warehouse
Valid Price Code or ‘BALE’
  
chr35_stackingpcode
46
AT
Repairing charge
Numeric. Max 4 digits.
  
chr35_repairing
47
AU
Repairing Price Code if different from warehouse
Valid Price Code or ‘BALE’
  
chr35_repairingpcode
48
AV
Stacking charge
Numeric. Max 4 digits.
  
chr35_packing
49
AW
Packing Price Code if different from warehouse
Valid Price Code or ‘BALE’
  
chr35_packingpcode

 

e-Invoicing addresses.  tab delimited Account is  mandatory .
Row 1, cell 1 must have content chr69
Row 2 columns are the database table names without the leading chr69_ e.g. acc, title
All columns are optional except those marked as mandatory.
Field No
Col Name
Name
Description
Mandatory
Chr69 field
1
A
Account e.g. 123456.P
Valid Client Account.
Yes
acc
3
  
Title/Name
Max 200
  
title
4
  
Address 1
Max 60
  
addr1
5
  
Address 2
Max 60
  
addr2
6
  
Address 3
Max 60
  
addr3
7
  
City
Max 20
  
city
8
  
Zip Code
max 40
  
zipcode
9
  
Municipality
max 20
  
municipality
10
  
Suburb
Max 20
  
suburb

 

e-Invoicing details.  tab delimited Mandatory fields are Account, Type and Effective Date.
Row 1, cell 1 must have content chr70
Row 2 columns are the database table names without the leading chr70_ e.g. acc, type
All columns are optional except those marked as mandatory.
Field No
Col Name
Name
Description
Mandatory
Chr70 field
1
A
Account e.g. 123456.P
Valid Client Account.
Yes
acc
2
  
Can Be E-Sender
0=No, 1 = Yes
  
canbeaesender
3
  
Can Be E-Receiver
0=No, 1 = Yes
  
canbeaereceiver
4
  
Can Be Tax Authority
0=No, 1 = Yes
  
canbeataxauthority
5
  
Legal Entity
0=No, 1 = Yes
  
legalentity
6
  
Natural Person
0=No, 1 = Yes
  
naturalperson
7
  
E-Inv Doc Type
table item
  
einvdoctype
8
  
E-Inv Doc ref
max 255
  
einvdocnumber
9
  
CURP
max 255
  
curp
10
  
State No
Max 255
  
stateno
11
  
Default Notes
a TEXT name (max 15 characters)
  
defaultnotes
12
  
Default Observation
a TEXT name (max 15 characters)
  
defaultobserv