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
94	CP	MSME	Y to Tick		chr20_canbeamsme
95	CQ	UDYAM Reg No	Max 25 chars		chr20_udyam
96	CR	EIC Code	Max 25 chars		chr20_eic
97	CS	AEO Cert No.	Max 25 chars		chr20_aeo
98	CT	UEN No.	Max 25 chars		chr20_uen
99	CU	FSSAI License No	Max 20 chars		chr20_fssai

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

Was this helpful? Yes No

Thanks for your feedback

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.

Recently viewed