TRADEIMP - Trade Import

What is

This process facilitates bulk TRADE entry for new business either as a take-on procedure for new Entities or for regular imports.

TRADEIMP imports TRADE records from a file located on ITAS server directly into ITAS. The format of the file is strictly controlled and any deviation from the format results in rejection of the entire import. TRADEIMP currently allows import of new trades (phys01 records), commissions (phys02), costs (phys03), options (phys04), price fixations (phys05), Columbia trade registrations (phys01af records) and traffic data. The file to import is a text TAB delimited file with an extension of ‘.Txt’; this can be created from an Excel worksheet.

S01 is used to define (View/Data Import/Export Fields/phys01 – [xx_imp01]) which TRADE fields can be included in the import file (Hivedome maintained list e.g. afi, warehouse, destination, port of origin) The list is maintained automatically with the mandatory fields needed by ITAS e.g. CounterParty, contract type, contract terms and also with the list of fields nominated in S01/View/Physicals/TRADE/Mandatories. The System Manager ticks which fields can be included on the import .txt file. The import file only needs the mandatory fields whereby any of the other selected fields can be included e.g. a warehouse/stock import would need Warehouse, Rotation ref etc whereas new business probably would not need those particular fields.

There is also an AUTO batch mode to execute the Trade import.

Files are placed in their own folder e.g. Itas\Import\Auto i.e. not the standard TradeImp Folders.

The auto process is fired by a batch command e.g. c:\itas\exec\a\a59 MenuBatch br /Path=c:\Itas\Import\Auto
The path must be present in the batch command and must exist
The process reads all the files (tab delimited .txt) in the folder and processes those with a Table Type of phys01, phys02, phys03 or phys05 and a column of phys01_takeonref
Other files are ignored.
All the relevant files found are moved to the working folder (e.g. c:\Itas\Import\Auto\InProgress). This folder is created automatically if it does not exist
The phys01 files are processed first, then the others
Each file is given a batch no. and moved to the old folder on completion (e.g. c:\Itas\Import\Auto\Old). This folder is created automatically if it does not exist. The name of the batch file in the old folder is date and batch number e.g. 22020407_Batch000101.txt
The import together with any errors is logged in Itas\Log\TradeImport.Log
The phys01 import line is rejected if the Takeon ref already exists
The phys02/3/5 import line is rejected if the Takeon ref does not exist or there are 2 or more contracts with the Takeon ref
A report of the import named TRADEIMP_BATCH000101.IRP is stored in OPRINT if the command string has the flag /Oprint=Y

1st Row Cell A determines the content of the file with the following types; phys01, phys01/splits, phys01/tranches, phys01/calloff, phys01af, phys02, phys03, phys04, phys05, phys06, phys11, phys12, phys13, phys14, phys24, phys28, phys30, phys31, phys40, phys75, phys97, phys98, ccc31, ccc42, ccc43, ccc44, ccc45, ccc46, ccc48, ccc52, fact06, traffic, trade, ttd, nexus, cmy112, equ01.

Cell A content = "phys01/calloff" is a specialist import to create splits of existing Purchase TRADE record with the new splits being nominated with Shipping Status 'Call-off' whereby generates phys09 data so that these intakes can be processed by PROSCHED to become Inventory. This process needs the import content 'phys01_contract' to locate its' basis template of data e.g. Dept, Counterparties with the import data being any of the S01 configured fields e.g. WareHouse Ref, Container, Lot Ref, Quantity, Price... Each column on the import file will be imported; if a cell is empty content and the data target field is configured as mandatory then a row rejection will occur.

Cell A content = "phys01/splits" is similar to '/calloff' with no automatic Shipping Status update and no phys09s created. New splits are create without reducing the header contract Qty i.e. works as 'Add Tonnage'

Cell A content = "phys01/tranches" is similar to '/splits' except creates tranches instead of splits.
Cell A content = "trade" will enable update of an existing TRADE with selected data elements i.e. those that do not have dependencies, except for code validation.

2nd row must contain the ITAS database names, as selected in S01 e.g. phys01_contype phys01_takeonref

for phys01/splits,phys01/tranches, phys01/trade:

i) there must be either a phys01_takeonref or phys01_contract column, not both
ii) the split/tranche may be set as a price fixing header if the phys01_fixfamily column contains the text HEAD

Row 3 onwards contains the data records to import. The last row is determined by the completely empty line.

To execute the import, select the drive, folder and filename of the file to import and click the Import button. The drive and folder are defaulted from a prior use of this application.

In the case of importing phys01 records, a batch no. is created which is unique to that import process. The batch no is stored in phys01_batchref on successfully imported records. TRADEIMP will reject the file from processing, if there are missing or extra fields to the master list. A log of failure rows will be produced for the user to re-enter. The failed entries will be due to the subsequent detailed TRADE validation e.g. invalid codes, inconsistent cross-referenced data.

There is a procedure to un-do an import by selecting from the Previous Imports grid and right-click for Delete import. The process ensures that the data is still virgin before allowing removal and a report is produced of the actions taken (failure and success).

An OPRINT report is also created listing each line of the import file, including an indicator if the record was rejected. The name of the OPRINT report for

phys01 records is: YYYYMMDD_Batchnnnnnn.IRP

phys02 records is: YYYYMMDD_ComsnImport_HHMMSS.IRP

phys03 records is: YYYYMMDD_CostsImport_HHMMSS.IRP

phys04 records is: YYYYMMDD_CmyOptionsImport_HHMMSS.IRP

phys05 records is: YYYYMMDD_FixationsImport_HHMMSS.IRP

phys14 records is: YYYYMMDD_SpecificationsImport_HHMMSS.IRP

phys01af records is: YYYYMMDD_TradeRegistrations_HHMMSS.IRP

traffic records is: YYYYMMDD_TrafficImport_HHMMSS.IRP

Where:

YYYYMMDD is the date

nnnnnn is the batch number and

HHMMSS is the time

After import the file is moved to the \Old folder and renamed. If the folder holding the file does not have a \Old sub folder, it is created. If the file already resides in a \Old folder it is not moved or renamed. The name of the new file the same as the OPRINT files except with an extension of ‘.Txt’

There is a process to remove (undo) the IMPORT of phys01 records using the batch reference. When an import has been completed satisfactorily, the contract references can not be re-used. Action right click…Un-Import. Any contracts which have been amended may not be reversed. The Un-import procedure creates an OPRINT report named YYYYMMDD_DeleteBatchnnnnnn.IRP and is also record in the log.

Data Rows

In general the data must be present in the file as it would be visible in the TRADE screen. The exceptions are:

Dates – Entered numerically so 12^th June 2007 would be in the file as 20070612, except shipping period which is entered as a date, period or range (e.g. JUN07)
Periods - Entered numerically so June 2007 would be in the file as 20070632
Phys01_fix (pricing Method: N for priced and F for F&O pricing
Phys01_contype (Contract Type): P for purchases and S for sales

phys01_fixtype (Type of Fix): AA for against actuals, BC for buyers calls etc.
Phys02_ratetype (Rate type): R for Rate, A for Amount, % for Percent etc.
phys02_payrec (Pay/rec): P for Pay, R for RecData rows are Columnb
phys01_posntype (Position Designator): S for "START", 1 for "START + 1 MONTH", 2 for "START + 2 MONTHS", 3 for "START + 3 MONTHS", X for "START - 1 MONTH"
Y for "START - 2 MONTHS", Z for "START - 3 MONTHS", E for "END", F for "END + 1 MONTH", G for "END + 2 MONTHS", H for "END + 3 MONTHS",

Data Field Names (Row 2 of the file)

Phys01

The fields which are permitted on the phys01 import must be those nominated in S01…View…Data Import Fields. The sequence of the columns is not important. The data fields indicated as mandatory in S01 must be present in the file and with content. Non mandatory items need not have a column in the file and if present may have a blank content. For example phys01_contype must be present and phys01_portorig does not. Other items are company specific, for example if the company has pack code nominated as mandatory in S01, then it must be present in the file. The phys01_contype determines ‘P’ (Purchase), ‘S’ () or ‘W’ (Warehoused Purchase). The ‘W’ command will create it’s ITAS contract references using S01 nominated ctrl30_licbase and ctrl30_autobase whereas ‘P’ and ‘S’ will follow the company standard setup.

Phys02

The phys02 column list is pre-defined and can have the following content:

Column A - phys02_contract or phys01_takeonref (MANDATORY)

Column B – phys02_agent (MANDATORY)

Column C - phys02_ccy (MANDATORY)

Column D- phys02_ratetype (MANDATORY)

Column E - phys02_pricecode

Column F - phys02_payrec (MANDATORY)

Column G - phys02_comrate (MANDATORY)

Column H - phys02_agref

Column I - phys02_pl

Column J - phys02_blind

Phys03

The phys03 column list is pre-defined and can have the following content:

Column A - phys03_contract or phys01_takeonref (MANDATORY)

Column B – phys03_code (MANDATORY)

Column C – phys03_supplier

Column D – phys03_ccy (MANDATORY)

Column E – phys03_ratetype (MANDATORY)

Column F – phys03_pricecode

Column G – phys03_payrec (MANDATORY)

Column H – phys03_rate (MANDATORY)

Column I – phys03_surcharge

Column J – phys03_pl

Column K – phys03_pole

Column L – phys03_roetype

Column M – phys03_roe

Column N – phys03_narrative

Column O – phys03_inccomm

Column P – phys03_notactualised

Column Q – phys01_memo2

Column R – phys03_containers (Only valid on ocean freight costs when pricecode is CONT – Per Container)

Column S – phys03_matrix

Column T - phys03_showininvoice

Phys04 (Commodity Options)

The phys04 column list is pre-defined and can have the following content:

Column A - phys04_contract or phys01_takeonref (MANDATORY)

Column B - phys04_commod (MANDATORY)

Column C - phys04_origin

Column D - phys04_grade

Column E - phys04_cmycode4

Column F - phys04_cmycode5

Column G - phys04_cmyctry

Column H - phys04_ccy

Column I - phys04_pricecode

Column J - phys04_conprice

Column K - phys04_quality

Column L – phys04_packcode

Column M - phys04_conterms

Column N - phys04_contermsport

Column O - phys04_arbit

Column P - phys04_cropyear

Column Q - phys04_portorig

Column R - phys04_shipweights

Column S - phys04_fclref

Column T - phys04_narrative

Phys05 / Phys52

The phys05 column list is pre-defined and can have the following content:

Column A - phys05_contract or phys01_takeonref (MANDATORY)

Column B - phys05_date, format is YYYYMMDD e.g. 20090513 (MANDATORY)

Column C - phys05_lots, numeric. The standard entry is an integer value unless TCCM/Price Fix Lots decimal places <> 0. Alternatively if the TRADE has been configured as 'Fix in MTs', decimal places are enabled to the maximum per TRADE weight code (MANDATORY)

Column D - phys05_commod, TCCM code (MANDATORY)

Column E - phys05_prompt, MMMYY or YYYYMMDD format e.g. MAY09 or 20090532

Column F - phys05_price, numeric max 6 decimal places (MANDATORY)

Column G - phys05_code, TERMCODES/Trade code (MANDATORY)

Column H – phys05_memo

Column I – blank (or phys01_memo2 if ctrl30_pfixstyle = C )

Column J – phys05_reassignid

Column K – phys05_summaryid

Column L – phys05_invref

Column M – phys05_use

Column N - phys05_flatprice

Column O - phys05_mktprice

Phys06 (Invoice Marking)

Flexible columns

Mandatory columns are: phys06_contract, phys06_docref, phys06_docdate, phys06_invval, phys06_type, phys06_invpc and phys06_onacc

Optional columns are: phys06_invbags, phys06_invwt, phys06_cost, phys06_margin, phys06_duedate, phys06_provdocref, phys06_costccy, phys06_vatcode, phys06_invqtycode, phys06_conquan, phys06_posted

Phys11 ( FX Cover)

The phys11 column list is pre-defined and must have the following content:

Column A - phys11_contract (MANDATORY)

Column B - phys11_fxdeal (MANDATORY)

Column C - phys11_fxcovered, numeric (MANDATORY)

Column D - phys11_roe numeric (MANDATORY)

Column E - phys11_roetype M or D (MANDATORY)

Phys12 (Cost Invoice Marking)

Flexible columns

Mandatory columns are: phys12_contract, phys12_code, phys12_docref, phys12_docdate, phys12_docvalue, phys12_percentactual, phys12_onacc

Optional columns are: phys12_invqty, phys12_vatcode

Phys13 (Commission Invoice Marking)

Flexible columns

Mandatory columns are: phys13_contract, phys13_agent, phys13_docref, phys13_docdate, phys13_docvalue, phys13_percentactual, phys13_onacc

Optional columns are: phys13_invqty, phys13_vatcode

Phys14 ( Quality Specifications)

The phys14 column list is pre-defined and must have the following content:

Column A - phys14_contract or phys01_takeonref (MANDATORY)

Column B -phys14_quality (MANDATORY)

Column C -,phys14_targetpc

Column D - phys14_maxpc

Column E - phys14_option

Column F - phys14_qualifier

Column G - phys14_loadportresult

Column H - phys14_dischargeresult

Column I - phys14_avgminpc

Column J - phys14_avgmaxpc

Column K - phys14_ourminpc

Column L - phys14_ourmaxpc

Column M - phys14_ouravgminpc

Column N - phys14_ouravgmaxpc

Column O - phys14_ouroption

Column P - phys14_minpcreq

Column Q - phys14_maxpcall

Column R - phys14_ratename

Column S - phys14_rate

Column T - phys14_mixpc

Column U - phys14_groupid

Column V - phys14_rate2

Phys01af

The phys01af column list is pre-defined and must have the following content:

Column A - phys01_contract or phys01_takeonref (MANDATORY)

Column B - phys01_finalbuyer

Column C - phys01_finalbuyerctry

Column D - phys01_registered

Column E - phys01_regshipmonth

Column F - phys01_regdate

Column G - phys01_regplace

Column H - phys01_regcode

Column I - phys01_fncalloccode

Column J - phys01_fncrevisioncode

Column K - phys01_serialdex

Column L - phys01_liqdate

Column M - phys01_reintegro

Column N - phys01_regtax

Column O - phys01_reintegroccy

Column P - phys01_reintegropcode

Column Q - phys01_regtaxccy

Column R - phys01_regtaxpcode

Phys28 (Cotton Pricing Master)


Column A	Phys28_contract	Must be a valid contract that is head of a price fixing family - Contract number = phys01_pricingsuffix
Column B	phys28_classtable	Must be a valid ccc41 class table
Column C	Phys28_mictable	Must be a valid ccc42 mic table
Column D	Phys28_strengthtable	Must be a valid ccc43 strength table
Column E	Phys28_unitable	Must be a valid ccc44 uniformity table
Column F	Phys28_extraneoustable	Must be a valid ccc45 ext matter table
Column G	Phys28_leaftable	Must be a valid ccc46 leaf table
Column H	Phys28_basetable	Date – Must be valid pd_base table
Column I	Phys28_invcutoffdate	Must be valid date
Column J	Phys28_invbcrate	Numeric
Column K	phys28_oldpenalty	Numeric
Column L	phys28_olddays	Integer
Column M	Phys28_olddaily	Y/N
Column N	phys28_accweight1,	Integer
Column O	phys28_accweight2	Integer
Column P	Phys28_cottonboard	Y/N
Column Q	phys28_firsthandler	Y/N
Column R	phys28_accoldcrop	Y/N
Column S	phys28_spottables	Y/N – If Y base date must be present
Column T	phys28_basedate	Must be valid date – Only valid if phys28_spottables = Y
Column U	phys28_minavebalewt	Integer
Column V	Phys28_classbase
Column W	Phys28_warehousetable	Must be a valid ccc48 warehouse table
Column X	Phys28_classpremtable	Must be a valid ccc41 class table

Phys4x tables – Pricing tables for the contract will be generated from the CCC table matching the imported name from columns B to H.

Phys30

The phys30 column list is pre-defined and must have the following content:

Column A - phys30_contract, Valid Open Purchase contract (DATA MANDATORY)

Column B - phys30_loan, Numeric, max 8 characters (DATA MANDATORY)

Column C - phys30_producer, Max 30 characters

Column D - phys30_agent, Valid Open Client Account code marked as Agent. The code entered will be compared against an existing ITAS client code beginning with ‘F’ and ending with ‘.P’. For example a valid entry for this column would be ‘01001’ where there exists an ITAS client code ‘F01001.P’

Column E - phys30_disburse, Format is YYYYMMDD e.g. 20100215

Column F - phys30_maturity, Format is YYYYMMDD e.g. 20100215

Column G - phys30_ascs, Format is YYYYMMDD e.g. 200100215

Column H - phys30_over, Format is ‘Y’ to indicate value exceeds $500,000

Column I - phys30_docs, Max 10 characters

Phys31 – Contract Options

The phys31 column list is pre-defined and must have the following content:

Column A - phys31_contract

Column B - phys31_type - DE = Destination, CT = Contract Terms, PT = Pay Terms , SW = Ship weights , OR = Origin, CY = Crop Year, GR = growth, TP = To Purchase , ME = Make Equity

Column C - phys31_code – the option code e.g. The port code , the contract terms code

Column D - phys31_option – B or S

Column E - phys31_takenup – Y or blank

Column F - phys31_termsport – Port for contract terms options

Column G - phys31_pricecode

Column H - phys31_premdisc

Phys40 – Premium Ranges

The phys40 column list is pre-defined and must have the following content:

Column A - phys40_contract, Valid Open Purchase contract (DATA MANDATORY)

Column B - phys40_type, C = Class , S = Strength, M = Mic, U = uniformity (DATA MANDATORY)

Column C - phys40_micfrom,

Column D - phys40_micto,

Column E - phys40_strengthfrom

Column F - phys40_strengthto

Column G - phys40_uniformityfrom

Column H - phys40_uniformityto

Column I - phys40_staplefrom

Column J - phy40_stapleto

Column K - phys40_gradelist

Column L - phys40_leaflist

Column M - phys40_reduced Y or Blank

Column N - phys40_belowgrade

Column O - phys40_staple100from

Column P - phys40_staple100to

Phys75 – Payment Splits

The phys75 column list is pre-defined and must have the following content:

Column A – phys75_contract

Column B – phys75_account – Client account code

Column C – phys75_percentage

Phys97 – Logistic Notes

The phys97 column list is pre-defined and must have the following content:

Column A – phys97_contract

Column B – phys97_type

Column C – phys97_date – Must be in DD/MM/YYYY format

Column D – phys97_note

Phys98 - Certs

The phys98 import can include the following columns in any order:

phys98_contract
phys98_certcode
phys98_certccy
phys98_certpcode
phys98_certprem
phys98_certno

TTD - Title transfer dates

To use this feature Hivedome need to configure the CMP privilege 'TRADEIMP/TTD' and the user needs to be appropriately accredited subsequently

Row 2 columns are
A phys01ae_contract
B phys01_ttd

C phys01_salettd

D phys01_saletbld

Data rows are A and B, both mandatory. Columns C and D are optional.
A value of ZERO in any of B, C and D will set those dates = zero. Leave blank if no change wanted.

Trade Updates

Row 2/ Column A must contain either phys01_contract or phys01_takeonref.

This process will also apply /Traffic maintenance.

Other columns may be any from this list:

phys01_estmat,phys01_memo,phys01_memo2,phys01_tradersmemo,phys01_polarisation,phys01_prealloc,
phys01_hedgelevel,phys01_roetargetdate,phys01_hedgeprice,phys01_origdiffnratio,phys01_admindest,phys01_adminterms,
phys01_arbit,phys01_businesstype,phys01_buyersecref,phys01_buyerorderno,phys01_clref,phys01_contermsport,
phys01_mill,phys01_counterpartysector,phys01_origvalndiffn,phys01_origvalncommod,phys01_origvalnperiod,
phys01_otherref,phys01_pricetype,phys01_sedcode,phys01_sino,phys01_trader,phys01_valndiffntype,phys01_valnccy
phys01_valncommod,phys01_valnperiod,phys01_valncode,phys01_valn,phys01_valndiffn,
phys01_afi,phys01_afidate,phys01_claim,phys01_trafficinit,phys01_trafficmemo,phys01_vessel,phys01_transhipvessel,
phys01_blref,phys01_shippingline,phys01_consignee,phys01_notify,phys01_portorig,phys01_portvia,phys01_portdest,
phys01_portoption,phys01_container,phys01_shipbuilt,phys01_bookingclose,phys01_journey,phys01_loadeta,
phys01_loaddate,phys01_eta,phys01_arrivaldate,phys01_shipflag,phys01_bldate,phys01_planshipdate,phys01_bookingno,
phys01_loadarrivaldate,phys01_departuredate,phys01_etd,phys01_deliverydate,phys01_destdecdate,phys01_marks,
phys01_fcl,phys01_fclref,phys01_warehouse,phys01_warehouseloc,phys01_shedid,phys01_warehousedate,phys01_warrant,
phys01_lotref,phys01_intakecode,phys01_bank,phys01_rentus,phys01_rentstart,phys01_rentend,phys01_bankref,
phys01_warehousetype,phys01_rhdinvdate,phys01_dom,phys01_factoryno,phys01_releasedate,phys01_releasecode,
phys01_vehiclereg,phys01_shiplineref,phys01_tenderdateout,phys01_frtforwarderref,phys01_frtforwarder,phys01_bookingtype,
phys01_haulierdelnr,phys01_haulierdeldate,phys01_contlastdate,phys01_transshipeta,phys01_contmarks,phys01_tender,
phys01_palletized,phys01_nopallets,phys01_altbags,phys01_pier,
phys01_uscuststatus,phys01_uscustcdatesent,phys01_uscustcbroker,phys01_uscustcentryno,phys01_uscustcentrydate,
phys01_uscustchtsusno,phys01_uscustchtsusquo,phys01_uscustcprog,phys01_uscustcfdaclear,phys01_uscustcclear,
phys01_uscustwdatesent,phys01_uscustwbroker,phys01_uscustwentryno,phys01_uscustwentrydate,phys01_uscustwhtsusno,
phys01_uscustwhtsusquo,phys01_uscustwprog,phys01_uscustwfdaclear,phys01_uscustwclear,phys01_uscustcentryyear,
phys01_uscustwentryyear,phys01_uscustcisfsentdate,phys01_uscustwisfsentdate,phys01_uscustclicenceno,
phys01_uscustwlicenceno,phys01_uscustcentryport,phys01_uscustwentryport,phys01_uscustwisfconfirmation,
phys01_uscustcisfconfirmation,phys01_uscustwfdaconfirmation,phys01_uscustcfdaconfirmation,phys01_uscustwisfconfdate,
phys01_uscustcisfconfdate,phys01_customsagency,phys01_wcustomsagency,phys01_customscountry,
phys01_wcustomscountry,phys01_railimporter,phys01_wcustomsexporter, phys01_origratio, phys01_exdock,
phys01_origvalndiffnccy, phys01_origvalndiffncode,

phys01_brzlsbidate, phys01_brzlrfbdate, phys01_brzetafbdate, phys01_brzbareqdate, phys01_brzbarecdate, phys01_brzbiupdateddate, phys01_brzshipinstrrecdate, phys01_brzbldraftsubdate, phys01_brzweightcontroldate, phys01_brznnblreceiptdate, phys01_brzorigblrecdate, phys01_brzsscocertenterdate, phys01_brziprecdate, phys01_brzphytoenterdate, phys01_brzcoenterdate, phys01_brzfumigcertrecdate, phys01_brzsscocertrecdate, phys01_brzdeadltermdate, phys01_brzdraftdeadldate, phys01_brzcargoallocdate, phys01_brzafi, phys01_brzipnumber, phys01_brzphytonumber, phys01_brzconumber, phys01_brzfumigcertnumber, phys01_brzcontainers, phys01_brzpartialshipment, phys01_brzsplitroll, phys01_brzfta, phys01_brzshiprestrict, phys01_brzcarrierrestrict, phys01_brzcarrycharge, phys01_brzperformance, phys01_brzproblem, phys01_brzrollreason, phys01_brzpersonterms, phys01_brzexportname, phys01_brzpurchaseterms, phys01_brzpersincharge,
phys01_brzshipterminal, phys01_brzshipinstrfirstdate, phys01_brzphytoissuedate, phys01_brzphytoreldate, phys01_brzcoreldate

Traffic Updates

Row 2/ Column A must contain either phys01_contract or phys01_takeonref AND any of the other columns from the list below:

General:

phys01_afi,phys01_afidate,phys01_claim,phys01_trafficinit

Shipping:

phys01_vessel, phys01_transvessel,phys01_blref,phys01_shippingline,phys01_consignee,phys01_notify,

phys01_portorig,phys01_portvia,phys01_portdest,phys01_portoption,phys01_container,

phys01_shipbuilt,phys01_bookingclose,phys01_journey,phys01_loadeta,

phys01_loaddate,phys01_eta,phys01_arrivaldate,

phys01_shipflag,phys01_bldate,phys01_planshipdate,phys01_bookingno,phys01_loadarrivaldate,

phys01_departuredate,phys01_etd,phys01_deliverydate,phys01_destdecdate,

phys01_marks,phys01_fcl,phys01_fclref, phys01_frtforwarder, phys01_frtforwarderref, phys01_pier

Warehouse:

phys01_warehouse,phys01_warehouseloc,phys01_shedid,

phys01_warrant,phys01_lotref,phys01_intakecode,phys01_warehousedate,

phys01_bank,phys01_rentus,phys01_rentstart,phys01_rentend,phys01_bankref,

phys01_warehousetype,phys01_rhdinvdate,phys01_dom,phys01_factoryno,

phys01_releasedate,phys01_releasecode, phys01_tender,

phys01_palletized, phys01_nopallets, phys01_pallettype,

phys01_haulierdelnr, phys01_haulierdeldate, phys01_contlastdate, phys01_transshipeta,
phys01_contmarks, phys01_haulageacc, phys01_vehicledriver, phys01_driverlicense,

phys01_trailerplate, phys01_trailerplate2, phys01_consdate

Memo/Marks:

phys01_altbags

Local Traffic:

Fact06 – Proman Stock

The fact06 column list is pre-defined and must have the following content:

Column A – Fact06_intakedate
Column B – Fact06_terminal
Column C – Fact06_warehouse
Column D – Fact06_shedid
Column E – Fact06_fromterm
Column F – Fact06_toterm
Column G – Fact06_commod
Column H – Fact06_origin
Column I – Fact06_grade
Column J – Fact06_cmycode4
Column K – Fact06_cmycode5
Column L – Fact06_cropyear
Column M – Fact06_conquan
Column N– Fact06_packcode
Column O – Fact06_bags
Column P – Fact06_owner
Column Q – Fact06_conval1
Column R – Fact06_conval2
Column S – Fact06_dept
Column T – Fact06_qa
Column U – Fact06_wtcode

Phys24 - Samples

Columns may be any of the permitted sample fields; these are:

phys24_source
phys24_approved
phys24_courier
phys24_amdinit
phys24_sendsampleto
phys24_foraccountof
phys24_amddate
phys24_warrant
phys24_sampleref
phys24_qua01number
phys24_sentreceived
phys24_shipmode
phys24_sampledate
phys24_uom
phys24_samplekilos
phys24_discardeta
phys24_courierref
phys24_reason
phys24_clientref
phys24_memo
phys24_container
phys24_client
phys24_sale
phys24_agent
phys24_approveddate
phys24_containerid
phys24_contract
phys24_warehouse

CCC41 – Cotton Class Pricing Table

Column A ccc41_name

Column B ccc41_up U = Upland , P= Pima

Column C ccc41_staple Integer 2 characters

Column D ccc41_grade Grade Code e.g. 11, 12

Column E ccc41_leaf Leaf code ( 1 to 7)

Column F ccc41_cropyear

Column G ccc41_pd Numeric – Units (CLB / PTS) depend on S01 setting

CCC42 – Cotton Micronaire Pricing Table

Column A ccc42_name

Column B ccc42_up U = Upland , P= Pima

Column C ccc42_micmin Numeric , 1 decimal place

Column D ccc42_micmax Numeric , 1 decimal place

Column E ccc42_staplemin Integer

Column F ccc42_staplemax Integer

Column G ccc42_cropyear

Column H ccc42_pd Numeric – Units (CLB / PTS) depend on S01 setting

CCC43 – Cotton Strength Pricing Table

Column A ccc43_name

Column B ccc43_up U = Upland , P= Pima

Column C ccc43_strengthmin Numeric , 1 decimal place

Column D ccc43_strengthmax Numeric , 1 decimal place

Column E ccc43_cropyear

Column F ccc43_pd Numeric – Units (CLB / PTS) depend on S01 setting

CCC44 – Cotton Uniformity Pricing Table

Column A ccc44_name

Column B ccc44_up U = Upland , P= Pima

Column C ccc44_uniformitymin Numeric , 1 - 100

Column D ccc44_uniformitymax Numeric , 1 – 100

Column E ccc44_cropyear

Column F ccc44_pd Numeric – Units (CLB / PTS) depend on S01 setting

CCC45 – Cotton Extraneous Pricing Table

Column A ccc45_name

Column B ccc45_up U = Upland , P= Pima

Column C ccc45_location T = Texas type , F = Other

Column D ccc45_matter Numeric Code

Column E ccc45_cropyear

Column F ccc45_pd Numeric – Units (CLB / PTS) depend on S01 setting

CCC46 – Cotton Leaf pricing table

Column A ccc46_name

Column B ccc46_up U = Upland , P= Pima

Column C ccc46_leaf Leaf code ( 1 – 7 )

Column D ccc46_grade Numeric Grade Code

Column E ccc46_cropyear

Column F ccc46_pd Numeric – Units (CLB / PTS) depend on S01 setting

CCC48 – Cotton Warehouse pricing table

Column A ccc48_name

Column B ccc48_warehouse Warehouse account

Column C ccc48_cropyear

Column D ccc48_pd Numeric – Units (CLB / PTS) depend on S01 setting

CMY112 – Equipment Codes

PROSCHED Asset Style i.e. ctrl30_assetstyle = P or U.

If any column after the mandatories is to be completed, the tab delimited .txt file must have all the Columns prior to the required column included with their heading

Column A cmy112_code Mandatory

Column B cmy112_descr Mandatory

Column C cmy112_terminal Terminal Code ex PHYSCODES Mandatory

Column D cmy112_warehouse Client account (CLI) marked as warehouse Mandatory

Column E cmy112_ownership L = Leased , O = Owned or R = Rented Mandatory

Column F cmy112_gainacc Nominal A/c

Column G cmy112_lossacc Nominal A/c

Column H cmy112_vehicle Y if a vehicle

Column I cmy112_owner Client account (CLI) marked as Service provider

Column J cmy112_ownereffectdate Date YYYYMMDD

Column K cmy112_prevowner Client account (CLI) marked as Service provider

Column L cmy112_prevownership L = Leased , O = Owned or R = Rented

Column M cmy112_oocenddate Date YYYYMMDD

Column N cmy112_oocendtime HHMM

Column O cmy112_oocstartdate Date YYYYMMDD

Column P cmy112_oocstarttime HHMM
Column Q cmy112_maintfreq D , W, M or Y

Column R cmy112_maintdays Integer

Column S cmy112_mainthrs Integer

Column T cmy112_lastmaintdate Date YYYYMMDD

Other Asset Styles i.e. ctrl30_assetstyle <> P nor U
If any column after the mandatories is to be completed, the tab delimited .txt file must have all the Columns prior to the required column included with their heading

Column A cmy112_code Mandatory

Column B cmy112_descr Mandatory

Column C cmy112_gainacc Nominal A/c

Column D cmy112_lossacc Nominal A/c

Column E cmy112_vehicle Y if a vehicle

EQU01 - Asset Register

Manual Asset Ref i.e. user supplies the Asset Reference . S01 ctrl30_assetref = M or I
If any column after the mandatories is to be completed, the tab delimited .txt file must have all the Columns prior to the required column included with their heading

Column A equ01_assetref Free format max , 9. Mandatory
Column B equ01_acqdat Date YYYYMMDD Mandatory
Column C equ01_acqccy Currency Code, gf/CDM
Column D equ01_assetdescr Free format, max 255
Column E equ01_equipcode Equipment Code ex ASSET/Maintain Equipment
Column F equ01_acqvalue Numeric, max 2 decimal places
Column G equ01_bookvalue Numeric, max 2 decimal places
Column H equ01_matcode Material Code ex ASSET/Maintain Material
Column I equ01_supplier Client A/c (CLI) set up as a service provider
Column J equ01_status Asset Status Code ex ASSET/Maintain Status
Column K equ01_user Free format 50 chars
Column L equ01_locationdescr Location Code ex ASSET/Maintain Physical Locations
Column M equ01_serialno Free format 30 characters
Column N equ01_dept Department code ex DEPT

Automatic Asset Ref i.e. ITAS assigns the Asset Reference. S01 ctrl30_assetref <> M nor I
Tab delimited .txt file. The following 13 columns must be in the file as listed.
Column 14 onwards may be any equ01 data field

Column A equ01_acqdat Date YYYYMMDD Mandatory
Column B equ01_acqccy Currency Code, gf/CDM
Column C equ01_assetdescr Free format, max 255
Column D equ01_equipcode Equipment Code ex ASSET/Maintain Equipment
Column E equ01_acqvalue Numeric, max 2 decimal places
Column F equ01_bookvalue Numeric, max 2 decimal places
Column G equ01_matcode Material Code ex ASSET/Maintain Material
Column H equ01_supplier Client A/c (CLI) set up as a service provider
Column I equ01_status Asset Status Code ex ASSET/Maintain Status
Column J equ01_user Free format 50 chars
Column K equ01_locationdescr Location ex ASSET/Maintain Physical Locations
Column L equ01_serialno Free format 30 characters
Column M equ01_dept Department code ex DEPT

NOTE: TRADEIMP is not a full functioning process available to all ITAS companies.