File name("chassiscust");
Description="Chassis Commission Customer File";
field="chscusno,cnsign,detfrdys,cureffdt";
keyfield="chscusno"


File name("costcenter");
Description="Revenue Center Master File";
keyfield="costcentr"
field="costcentr,costcentrds";

File name("frtcomfile");
Description="Freight Commission File";
field="voyptr,fcindx,bilno,cnsign,shipper,fcqty,fcconv,fcimp,fcexp,fctrans,fcdombox,fctrnbox,fctsb,fcchas,pcjlid";
keyfield="voyptr,fcindx";

File name("linecostcntrd")
Description="Revenue Center Charge Detail"
field="linnum,costcentr,chgitem"
keyfield="linnum,costcentr,chgitem"


File name("linecostcntr")
Description="Revenue Center Charge Header"
field="linnum,costcentr";
keyfield="linnum,costcentr"


File name("RANGECHGRATE");
Description="Range Charge Tier Rate File";
field="chgitm,effdate,endlvl,chgrate";
keyfield="chgitm,effdate desc,endlvl";


File name("wsordform");
Description="Order Form";
field="ordformnbr,iocode,ordformsts,ordformdat,ordformtim,wharfcode,ordcust,ordcustname,ordcustadd1,ordcustadd2,ordcustadd3,contnum,contsize,ship,shpnam,vgeno,arrdate,portld,portdc,weight,unitwgt,mesur,unitmsr,descr,marks,bilno,bilref,addedby,cnttpdsc,ashpnam,avgeno,aarrdate,shplincode";
keyfield="ordformnbr";
index[0]="byimpexp:iocode,ordformnbr";


File name("wsordformcan");
Description="Cancelled Order Form";
field="ordformnbr,ordfcdate,ordfctime,ordfcusr,ordfcrsn"
keyfield="ordformnbr";


File name("wswharf");
Description="Wharf";
field="wharfcode,wharfdesc";
keyfield="wharfcode";
 

File name("wsordchrg");
Description="Order Specific Charge";
field="ordnbr,chgitem,amount,currcode";
keyfield="ordnbr,chgitem";


File name("wscustrn");
Description="Customer Transactions";
field="concde,trantype,typenbr,transts,amount,runbal,trannbr,trandate,trantime,invnbr";
index[0]="wscustrnl1:concde,trandate,trantime";
index[1]="wscustrnl2:concde,trannbr desc";


File name("wsinvent");
Description="Inventory";
field="invid,cnsign,connum,voyref,bilref,dtlnbr,descr,pkgcde,marks,comcde,quan,quan1,weight,unitwgt,mesur,unitmsr,dmgtxt,trandate,trantime,tranuser,loccode,pinvid";
keyfield="invid";
index[0]="wsinventl1:trandate desc,trantime desc";
index[1]="wsinventl3:bilref";
view[0]="wsinventl2:*:quan1>0";


File name("wspinvent");
Description="Parent Inventory";
field="invid,cnsign,connum,voyref,bilref,dtlnbr,descr,pkgcde,marks,comcde,quan,quan1,weight,unitwgt,mesur,unitmsr,dmgtxt,trandate,trantime,tranuser,loccode";
keyfield="invid";


File name("wsordhead");
Description="Order Header";
field="ordnbr,trandate,trantime,tranuser,connum,voyref,cnsign,cnsadd,bilref";
keyfield="ordnbr";
index[0]="wsordhedl1:connum,voyref";


File name("wsorddetl");
Description="Order Detail";
field="ordnbr,invid,quanord,quangp";
index[0]="wsorddetl1:ordnbr,invid";



File name("wsldgmst");
Description="Lodgement Master";
field="wsldgcsn,wsldgcur,wsldgbal,wsldgsts";
keyfield="wsldgcsn,wsldgcur";


File name("wsldgtrn");
Description="Lodgement Transaction";
field="wsldgcsn,wsldgcur,wsldgnbr,wsldgtype,wsldgdptp,wsldgusr,wsldgdate,wsldgtime,wsldgamt,wsldgrcp,wsldgcqbk,wsldgcqno,wsldgcqpr,wsldgrnbl,rcppywird,rcppywirr,rfnnbr,ddepdate,ddepacc";
keyfield="wsldgcsn,wsldgcur,wsldgnbr";


File name("WISCONTP")
Description="Container Types"
field="cnttype,cnttpdsc"
keyfield="cnttype";


File name("WSACC")
Description="Account Master File"
field="accnum,accdesc"
keyfield="accnum";


File name("WSAMDCODE")
Description="Amendment Codes"
field="amdcode,amddesc"
keyfield="amdcode";


File name("WSASCHRG")
Description="Assessment Sheet General Charges"
field="asref,ascgprf,ascgitm,ascgquan"
keyfield="asref,ascgprf,ascgitm";


File name("WSASHEAD")
Description="Assessment Sheet"
field="asref,voyref,wsasdesc,wsascon,wsascom,wsascur,agtprfcde,wsasapsts,wsasapby,wsasapdt,wsasaptm,wsaschgto,wsdscntper,invnbr"
keyfield="asref";
index[0]="wsasheadl1:voyref";
view[0]="wsasheadl2:*:wsasapsts<>'A':";


File name("WSASDETAIL")
Description="Assessment Sheet Detail"
field="asref,chgprfcde,chgitm,quantity,rate,amount,description,effexrate"
index[0]="wsasdtlref:asref,chgprfcde,chgitm";


File name("WSASOT")
Description="Assessment Sheet Overtime Charges"
field="category,asref,arrdate,strdate,enddate,strtime,endtime,numwrker,numdoub,numtimhlf"
keyfield="category,asref,arrdate,strdate,enddate,strtime,endtime";


File name("WSASOTEMP")
Description="Assessment Sheet Overtime Workers"
field="category,asref,arrdate,strdate,enddate,strtime,endtime,empid"
keyfield="category,asref,arrdate,strdate,enddate,strtime,endtime,empid";


//File name("WSASINVMAP")
//Description="Assessment Sheet-Invoice Number mapping "
//field="asref,invnbr"
//keyfield="asref,invnbr";
//

File name("WSASSPCHG")
Description="Assessment Sheet Specific Charges"
field="asref,ascgitm,ascgamt,aspaytyp,ascgquan,asspcaddtl"
keyfield="asref,ascgitm";


File name("WSBLCHRG")
Description="B/L Specific Charges"
field="bilref,bilcgitm,bilcgamt,bilcgcur,bilpaytyp,blcgquan"
keyfield="bilref,bilcgitm";


File name("WSBLCON")
Description="B/L Container File"
field="refno,refcod,connum,efcod,conloc,concomm"
keyfield="refno,connum";


File name("WSBLDETL")
Description="Bill Of Lading Details"
field="bilref,dtlnbr,descr,pkgcde,weight,mesur,quan,quan1,marks,comcde,unitwgt,unitmsr,loctn,chgitm1,chgitm2,chgitm3,chgitm4,chgitm5,hscode"
keyfield="bilref,dtlnbr";


File name("WSBLDTCNAS")
Description="Bill Of Lading Detail To Container Association"
field="bilref,dtlnbr,connum"
keyfield="bilref,dtlnbr,connum";


File name("WSBLDTLPR")
Description="BL Details Group Profile"
field="bldtlfld,bldtlprf,bldtldsc"
keyfield="bldtlfld";


File name("WSBLHEAD")
Description="Bill of Lading Header"
field="ietype,dttype,voyref,bilno,itemno,porto,portld,portdc,portd,cnsacc,cnsign,cnsadd,shpacc,shipper,shpadd,ntfyacc,notify,ntfyadd,bilref,bilrefm,bilgrppro,rtcde,wftxcd,reqaprvl,atuser,atdate,attime,atcode,vluser,vldate,vltime,vlcode,hruser,hrdate,hrtime,hrcode,paymnt,gtpass,blcur,bilpsts"
keyfield="voyref,bilno,itemno";
index[0]="wsblhdprf:bilgrppro";
index[1]="wsblhdref:bilref";
index[2]="wsblhdrefm:bilrefm";
index[3]="wsblhdvoy:voyref";
index[4]="wsblhdcsn:cnsign,voyref";
view[0]="wsblhdpg:*:paymnt='Y' and gtpass<>'Y':";
view[1]="wsblhdrqa:*:reqaprvl='Y' and atcode<>'A':";

//view[2]="wsblhdcsn2:DISTINCT cnsign:";


File name("WSBLVEH")
Description="B/L Motor Vehicle file"
field="refno,carsnum,cartype,caryear,carloc,cargpno"
keyfield="refno,carsnum";
index[0]="wsblvehl:cargpno";


File name("WSCHGBAS")
Description="Charge Basis"
field="basiscde,basis"
keyfield="basiscde";


File name("WSCHGBASU")
Description="Charge Basis Units"
field="basiscde,unit"
keyfield="basiscde,unit";



File name("wschgitm");
Description="Charge Item Master File";
keyfield="chgitem"
field="chgitem,chgdesc,longdesc,chgdbtac,chgdbtsub,chgcdtac,sysitm,depitem,depchgitem,billinggrp";


File name("WSCHGITMR")
Description="Charge Item Rate"
field="chgitem,effdate,chgbasis,chgbasis1,chgbasis2,chgitmop,chgitmrte,chgprftyp,chgprfusg,chgprf,chgitmfac,chgitmper,chgdivsr,chgdivsr1,chgdivsr2,chground,chground1,chground2,chgunit,chgunit1,chgunit2,chgfixamt,chgminval,chgmaxval,chgitmcur,othchg1,othchg2,chgfunctn,prorate,decprecision,rangetype"
keyfield="chgitem,effdate";


File name("WSCHGPFLD")
Description="Charge Profile Level Detail File"
field="chgprfcde,chgitem,relchgitm"
keyfield="chgprfcde,chgitem,relchgitm";


File name("WSCHGPRF")
Description="Charge Profile Master File"
field="chgprfcde,chgprfdsc,chgsysdfn,chgfixitm,chgasfunc,confeeitm"
keyfield="chgprfcde";


File name("WSCHGPRFD")
Description="Charge Profile Detail File"
field="chgprfcde,chgitem,chgprfdl,chgprtabl,chgapprte,chgfdates,chgtdates,chgfdatad,chgtdatad,exchlydayf,exchlydayt"
keyfield="chgprfcde,chgitem";


File name("WSCOMM")
Description="Commodity Codes"
field="sitccd,sitcln,sitcsn"
keyfield="sitccd";


File name("WSCON")
Description="Container File"
field="connum,size,type"
keyfield="connum";


File name("WSCONSGN")
Description="Customer Master"
field="concde,connam,conadd,conadd2,conadd3,conadd4,conadd5,conemail,conemldoc,conphno,confax,concontac,concdtlm,concdtob,exmptint,custype,constatus,confname,conlname,intcycle,trn"
keyfield="concde";


File name("WSCONSTP")
Description="Container Size/Type Charge Profile"
field="prfsize,prftype,prfcode,prfusge,prfefdt,prfexdt"
keyfield="prfsize,prftype,prfcode";


File name("WSCONSZ")
Description="Container Sizes"
field="cntsize,cntszdsc"
keyfield="cntsize,cntszdsc";


File name("WSCOUNTRY")
Description="Country File"
field="contcd,contname"
keyfield="contcd";


File name("WSCUR")
Description="Currency Code"
field="currcode,curshrtnm,currdesc,bnkglac,bnkglacsf,depglac";
keyfield="currcode";


File name("WSCURHIS")
Description="Currency History"
field="currcode,currate,cureffdt"
keyfield="currcode,cureffdt";


File name("WSDISCNT")
Description="Discount File"
field="dscref,dsccgitm,dscnbr,dscamt,dscpercnt,dscreason,dscuser,dscapply"
keyfield="dscref,dsccgitm,dscnbr";


File name("WSEDILINK")
Description="EDI Link File"
field="linkid,linkname,definpfil,defoutfil,prognam"
keyfield="linkid";


File name("WSEDIPROG")
Description="EDI Upload Programs"
field="ediprgfil,ediprgdsc,edidir"
keyfield="ediprgfil";


File name("WSEDITRANS")
Description="EDI Transaction File"
field="linkid,codetype,extcode,intcode"
keyfield="linkid,codetype,extcode,intcode";


File name("WSEMPLOYEE")
Description="Employee File"
field="empid,empname"
keyfield="empid";


File name("WSEXMASC")
Description="Exempt Customer Master"
field="exmpcsn"
keyfield="exmpcsn";


File name("WSEXMASI")
Description="Exempt Commodity Master"
field="exmpitm"
keyfield="exmpitm";


File name("WSGATE")
Description="Gate"
field="gateid,gatedesc"
keyfield="gateid";


File name("WSGPCAN")
Description="GatePass Cancelled"
field="gpno,gpcdate,gpctime,gpcusr,gpcrsn"
keyfield="gpno";


File name("WSGPDETL")
Description="GatePass Detail"
field="gpno,gpdtlnbr,invid,gpquanty"
keyfield="gpno,gpdtlnbr,invid";


File name("WSGPHEAD")
Description="GatePass Header"
field="gpno,gpref,gpuser,gpdate,gptime,gprundate,gpruntime,gpcustrl,gpplate,gphauler,gpdriver,gpdevclk,gpgateoff,gpexit,gpstatus,gptype,gpcmt,ordnbr,gpdriverid,gpcstmdlv"
keyfield="gpno";
index[0]="wsgpheadl:gpref";
index[1]="wsgpheadl2:gpdate";


File name("WSHAULER")
Description="Hauler File"
field="hauler,hauleradd1,hauleradd2,haulertel,haulercnt"
keyfield="hauler";


File name("WSHBRFEE")
Description="Harbour Fee Rates"
field="maxton,hbrfee,effdate"
keyfield="maxton,effdate";


File name("WSHOLIDAY")
Description="Holiday"
field="hlydate,hlydesc"
keyfield="hlydate";



File name("WSINTCYCLE")
Description="Interest on Invoice Cycle"
field="cycleid,cycledesc,cycledays"
keyfield="cycleid";


File name("WSINVCAN")
Description="Invoice Cancelled"
field="invnbr,invcdate,invctime,invcusr,invcrsn"
keyfield="invnbr";


File name("WSINVDETL")
Description="Invoice Detail"
field="invnbr,invitm,invref,invcgamt,invcuramt,invdcamt,invcurdca,invpdto,invcon,invcgamtlcy,invcgaddtl,ordnbr,linenbr,actid"
keyfield="invnbr,invref,invitm,invcon";
index[0]="wsinvdtl1:invitm";
index[1]="wsinvdtl2:invref";
index[2]="wsinvdtl3:ordnbr";
index[3]="wsinvdtl4:actid";
view[0]="wsinvhddl:WSINVDETL.INVNBR, WSINVHEAD.INVDATE, WSINVHEAD.INVTIME, WSINVHEAD.INVAMT, WSINVHEAD.INVCUR, WSINVHEAD.INVSTS, WSINVDETL.INVITM, WSINVDETL.INVREF, WSINVHEAD.INVAMTPD, WSINVDETL.INVCGAMT, WSINVDETL.INVCURAMT, WSINVDETL.INVDCAMT, WSINVDETL.INVCURDCA, WSINVDETL.INVPDTO, WSINVDETL.INVCON, ordnbr,wsinvdetl.ACTID:WSINVDETL.INVNBR=WSINVHEAD.INVNBR:WSINVHEAD:";
view[1]="wsinvhddl2:WSINVDETL.INVNBR, WSINVHEAD.INVDATE, WSINVHEAD.INVTIME, WSINVHEAD.INVAMT, WSINVHEAD.INVCUR, WSINVHEAD.INVSTS, WSINVDETL.INVITM, WSINVDETL.INVREF, WSINVHEAD.INVAMTPD, WSINVHEAD.INVAMTDC, WSINVDETL.INVCGAMT, WSINVDETL.INVCURAMT, WSINVDETL.INVDCAMT, WSINVDETL.INVCURDCA, WSINVDETL.INVPDTO, WSINVDETL.INVCON :WSINVDETL.INVNBR=WSINVHEAD.INVNBR:WSINVHEAD:";


File name("WSINVHEAD")
Description="Invoice Header"
field="invnbr,invsts,invdate,invtime,invamt,invamtpd,invamtdc,invcur,invcust,invusr,invtype,invamtlcy,remarks,gvoyref,poref"
keyfield="invnbr";
index[0]="wsinvhdl1:invcust,invdate";
index[1]="wsinvhdl2:invdate,invcur";


File name("WSLINE")
Description="Line Master File"
field="linnum,linnam,agtnum"
keyfield="linnum";


File name("WSLOC")
Description="Location File"
field="loccode,location"
keyfield="loccode";


File name("WSOTCAT")
Description="Overtime Categories"
field="category,description"
keyfield="category";


File name("WSOTRATE")
Description="Overtime Rates"
field="effdate,category,dblrate,tmhfrate"
keyfield="effdate,category";


File name("WSPACK")
Description="Packaging Master"
field="paccde,pacdes"
keyfield="paccde";


File name("WSPAYTYP")
Description="Payment Types"
field="paytyp,paydsc,sysdfn"
keyfield="paytyp";


File name("WSPLTFEE")
Description="Pilotage Fee Rates"
field="maxton,pltdpndnt,pltfee,effdate"
keyfield="maxton,pltdpndnt,effdate";


File name("WSPORT")
Description="Ports"
field="iprtcd,iprtnm,contcd,locidf"
keyfield="iprtcd";


File name("WSPRFGRP")
Description="Profile Group"
field="chgprfgrp,chgprfgrpd,sysitm"
keyfield="chgprfgrp";


File name("WSPRFGRPD")
Description="Profile Group Group Profile"
field="chgprfgrp,chgprfcde"
keyfield="chgprfgrp,chgprfcde";


File name("WSRCPCAN")
Description="Receipt Cancelled"
field="rcpnbr,rcpcdate,rcpctime,rcpcusr,rcpcrsn"
keyfield="rcpnbr";


File name("WSRCPDETL")
Description="Receipt Detail"
field="rcpnbr,rcpitm,rcpref,rcpcgamt,rcpcuramt,rcpdcamt,rcpcurdca,rcpcon,rcppdto,rcpinvnbr,rcpcgamtlcy,rcpcgaddtl,ordnbr,linenbr,actid"
keyfield="rcpnbr,rcpref,rcpitm,rcpcon,rcpinvnbr";
index[0]="wsrcpdtl1:rcpitm";
index[1]="wsrcpdtl2:rcpinvnbr";
index[2]="wsrcpdtl3:rcpref";
index[3]="wsrcpdtl4:ordnbr";
index[4]="index5:actid";
view[0]="wsrcphddl: WSRCPDETL.RCPNBR, WSRCPHEAD.RCPDATE, WSRCPHEAD.RCPTIME, WSRCPHEAD.RCPCUR, WSRCPHEAD.RCPSTS, WSRCPDETL.RCPITM, WSRCPDETL.RCPREF, WSRCPHEAD.RCPAMT, WSRCPDETL.RCPCGAMT, WSRCPDETL.RCPCURAMT, WSRCPDETL.RCPDCAMT, WSRCPDETL.RCPCURDCA, WSRCPDETL.RCPPDTO, WSRCPDETL.RCPCON, WSRCPDETL.RCPINVNBR, ordnbr,WSRCPDETL.ACTID :WSRCPDETL.RCPNBR=WSRCPHEAD.RCPNBR:WSRCPHEAD:";
view[1]="wsrcphddl2:WSRCPDETL.RCPNBR, WSRCPHEAD.RCPDATE, WSRCPHEAD.RCPTIME, WSRCPHEAD.RCPCUR, WSRCPHEAD.RCPSTS, WSRCPDETL.RCPITM, WSRCPDETL.RCPREF, WSRCPHEAD.RCPAMT, WSRCPDETL.RCPCGAMT, WSRCPDETL.RCPCURAMT, WSRCPDETL.RCPDCAMT, WSRCPDETL.RCPCURDCA, WSRCPDETL.RCPPDTO, WSRCPDETL.RCPCON, WSRCPDETL.RCPINVNBR :WSRCPDETL.RCPNBR=WSRCPHEAD.RCPNBR:WSRCPHEAD:";


File name("WSRCPHEAD")
Description="Receipt Header"
field="rcpnbr,rcpsts,rcpdate,rcptime,rcpamt,rcpamtdc,rcpcur,rcpusr,rcrcvby,rcpamtlcy,cnsadd,gvoyref"
keyfield="rcpnbr";
index[0]="wsrcphdl1:rcpusr,rcpdate";
index[1]="wsrcphdl2:rcpdate,rcpcur";


File name("WSRCPPYDL")
Description="Receipt Payment Detail"
field="rcpnbr,rcppytp,rcppyamt,rcppycmt,rcppycqbk,rcppycqno,rcppycqpr,rcppycctp,rcppyccno,rcppyccxd,rcppyccnm,rcppydctp,rcppydcno,rcppydcxd,rcppydcnm,rcppywird,rcppywirr,rcppylcsn,wsldgbal"
//keyfield="rcpnbr";
index[0]="wsrcppyd1:rcpnbr,rcppytp";


File name("WSSHIP")
Description="Ship File"
field="shpnum,shpnam,shptype,maxgrt,maxnrt,length,drght,beam,vesopr,regist,confrc,stpcod,bowtrs,vesrgt,imocde,loadtype"
keyfield="shpnum";


File name("WSSHPRPT")
Description="Ship Report File"
field="ship,vgeno,arrdate,arrtime,depdate,deptim,strdate,strtim,stpdate,brth,duedate,duetim,portl,portn,stgdate,agtnum,water,passenger,pltpenper,crsdisper,pltname,linenbr,voyptr,iocode,dsempassr,styovpassr,nvispassr,manregno,recvdate,poref"
keyfield="ship,arrdate,vgeno";
index[0]="wsshprptl:voyptr";
index[1]="wsshprptd:arrdate";
view[0] ="wsblhdshrt:ship,vgeno,arrdate,arrtime,depdate,deptim,strdate,strtim,stpdate,brth,duedate,duetim,portl,portn,stgdate,agtnum,water,passenger,pltpenper,crsdisper,pltname,linenbr,voyptr,ietype,dttype,voyref,bilno,itemno,porto,portld,portdc,portd,cnsacc,cnsign,cnsadd,bilref,bilrefm,bilgrppro,rtcde,wftxcd,reqaprvl,atuser,atdate,attime,atcode,vluser,vldate,vltime,vlcode,hruser,hrdate,hrtime,hrcode,paymnt,gtpass:voyref=voyptr:wsblhead"


File name("WSSYSPRM")
Description="System Parameters"
field="cmpname,cmpaddr1,cmpaddr2,cmpaddr3,cmpaddr4,cmpaddr5,cmptele,cmpfax,cmpemail,cmpcontact,lrcpno,linvno,lgpno,rcpvarnce,datefmt,timefmt,lcdnno,blholddft,useblval,useblapv,invexrtdt,lldgno,lrfnno,lordfrmid";
keyfield="";


File name("WSTMPBL")
Description="EDI Temporary BL File"
field="tranmisid,bilnum,itemno,masterbl,ietype,dttype,porto,portld,portdc,portd,cnsacc,cnsign,cnsadd,shpacc,shipper,shpadd,ntfyacc,notify,ntfyadd,bilgrppro,reqaprvl,transfer,trfuser,trfdate,trftime"
keyfield="tranmisid,bilnum";


File name("WSTMPBLC")
Description="EDI Temporary BL Container File"
field="tranmisid,bilnum,connum,consize,contype,conloc,concomm,efcod,seal1,seal2,seal3,seal4,seal5,undgcode,settemp,mintemp,maxtemp,refhumid"
keyfield="tranmisid,bilnum,connum";


File name("WSTMPBLCHG")
Description="EDI Temporary BL Charges File"
field="tranmisid,bilnum,bilcgitm,bilcgamt,bilcgcur,bilpaytyp,blcgquan"
keyfield="tranmisid,bilnum,bilcgitm";


File name("WSTMPBLD")
Description="EDI Temporary BL Detail File"
field="tranmisid,bilnum,dtlnbr,descr,pkgcde,weight,mesur,quan,marks,comcde,unitwgt,unitmsr,loctn,chgitm1,chgitm2,chgitm3,chgitm4,chgitm5,hscode"
keyfield="tranmisid,bilnum,dtlnbr";


File name("WSTMPBLDC")
Description="EDI Temporary BL Detail to Container Association File"
field="tranmisid,bilnum,dtlnbr,connum"
keyfield="tranmisid,bilnum,dtlnbr,connum";


File name("WSTMPBLV")
Description="EDI Temporary BL Vehicle File"
field="tranmisid,bilnum,carsnum,cartype,caryear,carloc"
keyfield="tranmisid,bilnum,carsnum";


File name("WSTRANMIS")
Description="EDI Transmission File"
field="tranmisid,linkid,dateadd,addedby,timeadded,voyref,bilgrppro,blcur"
keyfield="tranmisid";


File name("WSTRDGRP")
Description="Trade lane grouping"
field="tradelne,contcde"
keyfield="tradelne,contcde";


File name("WSTRDLNE")
Description="Trade Lanes"
field="tradelne,tradedsc"
keyfield="tradelne";


File name("WSVOYCON")
Description="Voyage Container"
field="voyref,connum,gateout,gatepsno,gatein,gateintm,gateinby,demstart,detstart,dprtdate,tobeshpd,strduedat,seal1,seal2,seal3,seal4,seal5,driver,license,contsts,dttype,strpdate,strptime,strpby,stufdate,stuftime,stufby,stuford,wharfage,undgcode,settemp,mintemp,maxtemp,refhumid"
keyfield="voyref,connum";
index[0]="wsvoyconl:gatepsno";
index[1]="wsvoyconl1:connum,voyref";


File name("WSVSLTYP")
Description="Vessel Type"
field="vsltyp,vsltypdes"
keyfield="vsltyp";


//*************************************************************

File name("WSCDNHEAD")
Description="Credit Note Header"
field="cdnnbr,cdnsts,cdninvnbr,cdndate,cdntime,cdnamt,cdncur,cdncust,cdnusr,cdnamtlcy,cdncmt";
keyfield="cdnnbr";
index[0]="wscdnhdl1:cdninvnbr";
index[1]="wscdnhdl2:cdnusr,cdndate";
index[2]="wscdnhdl3:cdndate,cdncur";


File name("WSCDNDETL")
Description="Credit Note Detail"
field="cdnnbr,cdnitm,cdnref,cdncgamt,cdncon,cdncgamtlcy,linenbr"
keyfield="cdnnbr,cdnref,cdnitm,cdncon";
index[0]="wscdndtl1:cdnitm";
view[0]="wscdnhddl: WSCDNDETL.CDNNBR, WSCDNHEAD.CDNDATE, WSCDNHEAD.CDNTIME, WSCDNHEAD.CDNCUR, WSCDNHEAD.CDNSTS, WSCDNDETL.CDNITM, WSCDNDETL.CDNREF, WSCDNHEAD.CDNAMT, WSCDNDETL.CDNCGAMT, WSCDNDETL.CDNCON, WSCDNHEAD.CDNINVNBR :WSCDNDETL.CDNNBR=WSCDNHEAD.CDNNBR:WSCDNHEAD:";



File name("WSCDNCAN")
Description="Credit Note Cancelled"
field="cdnnbr,cdncdate,cdnctime,cdncusr,cdncrsn"
keyfield="cdnnbr";


File name("WSBLCMT");
Description="B/L Comments"
field="bilref,cmtnbr,blcmt,usrid,trantime,trandate"
keyfield="bilref,cmtnbr";


File name("WSRFNHEAD")
Description="Refund Header"
field="rfnnbr,rfnsts,rfnrcpnbr,rfndate,rfntime,rfnamt,rfncur,rfnusr,rfnamtlcy,rfncmt,rcrcvby,rcppycqbk,rcppycqno,rcppycqpr,wsldgcsn,wsldgnbr,rcppywird,rcppywirr,rfnrmkcode";
keyfield="rfnnbr";
index[0]="wsrfnhdl1:rfnrcpnbr";
index[1]="wsrfnhdl2:rfnusr,rfndate";
index[2]="wsrfnhdl3:rfndate,rfncur";


File name("WSRFNDETL")
Description="Refund Detail"
field="rfnnbr,rfnitm,rfnref,rfncgamt,rfncon,rfncgamtlcy,linenbr,rfncgcura,actid"
keyfield="rfnnbr,rfnref,rfnitm,rfncon";
index[0]="wsrfndtl1:rfnitm";
view[0]="wsrfnhddl: WSRFNDETL.RFNNBR, RFNDATE, RFNTIME, RFNCUR, RFNSTS, RFNITM, RFNREF, RFNAMT, RFNCGAMT, RFNCON :WSRFNDETL.RFNNBR=WSRFNHEAD.RFNNBR:WSRFNHEAD:";



File name("WSRFNRCPT")
Description="Refund Receipts"
field="rfnnbr,rcpnbr"
keyfield="rfnnbr,rcpnbr";
index[0]="wsrfnrcp1:rcpnbr";



File name("WSRFNCAN")
Description="Refund Cancelled"
field="rfnnbr,rfncdate,rfnctime,rfncusr,rfncrsn"
keyfield="rfnnbr";


$dt= new dbTableDef('RefundRemarks');
Description = "Refund Remarks";
field="rfnrmkcode,rfnremarks";
keyfield="rfnrmkcode";


//*******Job costing

File name("Drivers");
Description="Drivers";
keyfield="drlicence"
field="fname,mname,sname,drlicence,expdate,licencetype,address1,address2,address3";


File name("MotorBodyType");
Description="MotorBodyType";
index[0]="index1:typeid"
keyfield="typeid"
field="bodytype,typeid";


File name("MotorMake");
Description="MotorMake";
index[0]="index1:makeid"
keyfield="makeid"
field="make,makeid";


File name("MotorVehicle");
Description="MotorVehicle";
keyfield="platenum"
field="make,makeyear,platenum,cassisnum,insurexpdate,fitexpdate,regexpdate,bodytype,model";


File name("wscustyp");
Description="wscustyp";
keyfield="custype"
field="custype,custypdsc";


File name("wsjob");
Description="wsjob";
keyfield="jobid"
field="jobid,bilno,cnsign,cnsadd,shipper,shpadd,notify,ntfyadd,bilparty,biltonam,biltoadd,shpnum,arrdate,arrtime,arrplace,jobsts,cnsacc,shpacc,ntfyacc,portd,jobdesc";


File name("WSJOBACT");
Description="WSJOBACT";
keyfield="jobid, actid"
field="jobid,actid,actcur,actdesc,chgprfgrp,qtnum,actsts,strdate,enddate,strtime,endtime,actcmt,delreq,vehreg,vehdriver,truckcmpy,truckext,asgndelvdate,delrcvby,recpid,recpidtype,recpidexp,datedelv,depreq,estenddate,estendtime";


File name("WSJOBACTDETLS");
Description="WSJOBACTDETLS";
keyfield="jobid, actid, chgitem"
field="jobid,actid,chgitem,chgitmcur,chgsrc,estimate,cost";


File name("wsjobitmcnas");
Description="wsjobitmcnas";
field="jobid,dtlnbr,connum";


File name("wsjobitmdetl");
Description="wsjobitmdetl";
keyfield="jobid, dtlnbr"
field="jobid,dtlnbr,descr,pkgcde,weight,mesur,quan,quan1,marks,comcde,unitwgt,unitmsr,loctn,chgitm1,chgitm2,chgitm3,chgitm4,chgitm5";


File name("wsquotdtl");
Description="wsquotdtl";
index[0]="index1:jobid"
keyfield="qtnum,jobid,actid,chgitem"
field="qtnum,jobid,actid,chgitem";


File name("wsquothdr");
Description="wsquothdr";
keyfield="qtnum";
field="qtnum,qtdate,jobid,qtsts,qtusr,qttotal,qtcur";


File name("CustomsOffice")
Description="Customs Office"
field="custmcode,custmoffice";
keyfield="custmcode";


//Request for Approval Files
File name("SYSPROCAPRV");
Description="Process Needing Approval";
field="proccode,procname,aprvtype,alwusrapv";
keyfield="proccode";
index[0]="sysautproc1:procname";


File name("SYSUSRAUT");
Description="Users Authorized to Approve Process";
field="proccode,usrid";
keyfield="proccode,usrid";


File name("SYSAPPROVALREQ");
Description="Processes Sent for Approval";
field="appvid,proccode,sendusrid,senddate,sendtime,requeststs,respusrid,respdate,resptime,aprvtype";
keyfield="appvid";


File name("SYSAPRREQDTL");
Description="Approval Request Details";
field="appvid,dtlnbr,reqdesc";
keyfield="appvid,dtlnbr";

// End Request for Approval Files

File name("wsfrtchg");
Description="Charge Item Group";
field="frtchgitm,itmgrp";
keyfield="frtchgitm,itmgrp";


File name("HSCODES");
Description="H.S. Code File";
field="hscode,hsdesc";
keyfield="hscode";


File name("SHIPLINE")
Description="Shipping Line File"
field="shplincode,shplinname"
keyfield="shplincode";


File name("CarrierCode")
Description="PCS Carrier Code "
field="scac,linnam,agtnam";
keyfield="scac";


File name("blheadextn");
Description="B/L Header Extension";
field="bilref,arrntsent";
keyfield="bilref";


File name("WSCHGITMPU")
Description="Charge Item Profile Usage"
field="chgprfusg,codedesc"
keyfield="chgprfusg";


File name("SYSSECURITY")
Description="System Security"
field="maxnbrusr,concursess"


File name("BillingGroup")
Description="Billing Group"
field="billinggrp,billingtxt,sysdfn"
keyfield="billinggrp";