Opera II Data Structure

(1)

(2)

Name

Caption

Comment

Type Length

Rule

BACS

BACS Banks

BACSBANK

BANKCODE BACS Bank C 15

STYLEID BACS Style ID N 3

BACS Formats

BACSFORMAT

FORMATTYPE Header/Body/Footer C 1

FORMATID BACS Format ID N 3

SEQUENCE Sequence N 2

FORMULA Formula M 10

BACS Styles

BACSSTYLE

STYLEID BACS Style ID N 3

HDRFORMID BACS Header Format ID N 3 BODYFORMID BACS Body Format ID N 3 FOOTFORMID BACS Footer Format ID N 3 VALUEDATE Value Date required L 1

VOLID Volume ID required L 1

AUTHID Authorisation ID required L 1 VOLNO Volume Number required L 1

(3)

ECB Activity Log

AALOG

AA_ACNT Bank Account C 8

AA_CNTR Cost Centre C 4

AA_USER User ID C 8

AA_DATE Date of Activity D 8

AA_TIME Time of Activity C 8

AA_BKSOFT Banking Software C 8

AA_FUNC Function Code C 8

AA_EXTRA Extra Data C 10

ECB Bank Balances

ABBAL

AB_ACNT Bank Account C 8

AB_CNTR Cost Centre C 4

AB_DLDATE Date of Bal. Update D 8 AB_DLTIME Time of Bal. Update C 8 AB_TIMETXT Text Time of Update C 35 AB_STATBAL Statement Balance N 12

AB_CLRBAL Cleared Balance N 12

AB_1DCBAL 1 Day Cleared Bal. N 12 AB_2DCBAL 2 Day Cleared Bal. N 12

AB_CREDITS No. of Credits N 5

AB_DEBITS No. of Debits N 5

AB_CREVAL Credit Value N 12

AB_DEBVAL Debit Value N 12

AB_CCVAL Cleared Credit Value N 12 AB_UCVAL Uncleared Credit Val N 12 AB_CURBAL Current CB Balance N 12 AB_RECBAL Reconc. CB Balance N 12

AB_FCURR Currency Code C 3

AB_USER User ID C 8

ECB Functions

ABFUNC

AF_BKSOFT Banking Software C 8

AF_FUNC Function Code C 8

AF_NAME Function Name C 30

AF_FILENO Software File Number C 1

AF_TYPE Return Value Type C 1

ECB Function Params

ABPRMS

AM_BKSOFT Banking Software C 8

AM_FUNC Function Code C 8

AM_PARM Parameter ID N 3

AM_NAME Parameter Name C 20

AM_TYPE Parameter Type C 1

AM_PTR Pointer Flag L 1

(4)

Name

Caption

Comment

Type Length

Rule

CASH BOOK

ECB Function Params

ABPRMS

AM_RETSTRU Return Struct. Flag L 1

ECB Software Names

ABSOFT

AW_BKSOFT Software Code C 8

AW_BSNAME Software Name C 30

AW_DOS DOS Compatible Flag L 1

AW_WIN Windows Compat. Flag L 1 AW_SWPATH1 File Location 1 C 60 AW_SWPATH2 File Location 2 C 60 AW_SWPATH3 File Location 3 C 60

ECB Code Conversions

ACCODE

AV_BKSOFT Banking Software C 8

AV_FUNC Function Code C 8

AV_PARM Parameter ID N 3

AV_PART Component ID N 3

AV_FROM Code to Convert From C 20

AV_TO Code to Convert To C 20

ECB Data Mapping

ADMAP

AD_BKSOFT Banking Software C 8

AD_FUNC Function Code C 8

AD_PARM Parameter ID N 3

AD_PART Component ID N 3

AD_NAME Component Name C 20

AD_TYPE Component Type C 1

AD_SIZE Component Size N 4

AD_DPS Component Decimals N 1

AD_PADDING No.of Padding Chars N 1 AD_DSEND Opera Data To Send C 20 AD_DSTORE ECB Data To Store C 20 AD_CSEND Process Source Data C 35 AD_CSTORE Process Target Data C 35 AD_VERSION Function Version No. N 1

ECB Payment Details

ADPOUT

AU_ACNT Bank Account C 8

AU_CNTR Cost Centre C 4

AU_CBTYPE Cashbook Type C 2

AU_ENTRY Cashbook Entry Ref. C 10 AU_PBANK Payee Bank A/c No. C 9 AU_PSORT Payee Bank Sort Code C 8 AU_ACCOUNT Ledger Account Code C 12 AU_NAME Ledger Account Name C 35

(5)

ECB Payment Details

ADPOUT

AU_SOURCE Source Ledger ID C 1

AU_HOME Home Value N 12

AU_FCVAL Foreign Value N 12

AU_FCURR Foreign Currency C 3

AU_FCDEC Currency Decimals N 1

AU_FCMULT Currency Mult Flag L 1

AU_FCRATE Exchange Rate N 11

AU_ECBTYPE ECB Type C 1

AU_ECBPAYD ECB Value Date D 8

AU_PSTDATE ECB Transaction Date D 8

AU_POSTGRP Group Posting N 5

AU_SRCCO Source Company ID C 1

AU_PAYID Payment ID - ECB Unique Payment ID supplied by Banking Softwarewhen payment is posted.

12 N AU_BATCHID Payment Batch ID Payment Batch Item ID supplied by Banking Softwarewhen

payment is posted. This shows the number ofthe item contained within the batch payment.

12 N

AU_REFER Transaction Ref. C 18

AU_INPUTBY Payment Input By C 8

Entries

AENTRY

AE_ACNT Account Bank Account C 8 AE_CNTR Cost Centre Cost Centre for the Bank Account C 4 AE_CBTYPE Cashbook Type Must exist on ATYPE file C 2

AE_ENTRY Entry Number C 10

AE_RECLNUM Reconcile Number Reconciliation Number (Empty before the bankreconciliation) obtained from the Bank Accountfile. If this field is not empty then this recordhas been reconciled.

6 N

AE_RECDATE Reconcile Date Date statement was reconciled. D 8 AE_LSTDATE Last Posting Date Last date transaction posted. Updated when thisrecord is added

to. D 8

AE_FRSTAT From Statement The From statement no. This is entered at thestart of a bank

reconciliation N 8 AE_TOSTAT To Statement The To statement no. This is entered at the startof a bank

reconciliation

8 N AE_STATLN Statement Line Internally Generated Number. Represents the orderon the Bank

Statement.Incremented in steps of 10 or Entered

6 N AE_ENTREF Entry Reference This is an optional field, but us likely tocontain things like the

cheque number etc. C 15 AE_VALUE Value The posting amount in the currency of the account.Negative is a

payment, positive is a receipt. N 12 AE_RECBAL Reconciled Balance The Reconciled Balance after this line has beenreconciled in the

currency of the account.

12 N AE_REMOVE Remove Flag True if this item is to be removed from the CashBook. L 1

(6)

Name

Caption

Comment

Type Length

Rule

CASH BOOK

Entries

AENTRY

AE_TMPSTAT Temp Statement Line This is populated when a part reconciliation hasbeen done. N 6

AE_COMPLET Completed Batch L 1

AE_POSTGRP Group Posting N 5

SQ_CRDATE Date Created D 8

SQ_CRTIME Time Created C 8

SQ_CRUSER User Created C 8

SQ_AMDATE Date Last Amendment D 8 SQ_AMTIME Time Last Amendment C 8 SQ_AMUSER User Last Amended C 8 AE_COMMENT Comment Comment field - used as a title for batch entries. C 40

AE_PAYID Payment ID - ECB N 12

AE_BATCHID Batch ID - ECB N 12

AE_BRWPTR Reconcile Pointer C 2

ID Unique ID N 10

ECB Hook Names

AHKNAM

AH_CODE Hook Code C 2

AH_NAME Hook Name C 10

AH_DESC Hook Description C 40

ECB Payment Headers

AHPOUT

AO_ACNT Bank Account C 8

AO_CNTR Cost Centre C 4

AO_CBTYPE Cashbook Type C 2

AO_ENTRY Cashbook Entry Ref. C 10 AO_STATUS Payment Status TLA C 3 AO_STATTXT Payment Status Desc. C 35 AO_STDATE Date of Status Upd. D 8 AO_STTIME Time of Status Upd. C 8 AO_REASON Reason for Rejection C 50 AO_ACTPAY Actual Payment Date D 8

AO_FCVAL Foreign Value N 12

AO_FCURR Foreign Currency C 3

AO_FCDEC Currency Decimals N 1

AO_HOME Home Value N 12

AO_TOTDEB Total Amount Debited N 12

AO_LOCK Processing Lock L 1

AO_PAYID Payment ID - ECB Unique Payment ID supplied by Banking Softwarewhen payment is

posted. N 12

AO_BATCHID Payment Batch ID Payment Batch Item ID supplied by Banking Softwarewhen payment is posted. Here this shows the totalnumber of items contained within the batchpayment.

12 N

AO_ECBTYPE ECB Type C 1

AO_RAISED Date Payment Raised D 8

(7)

ECB Payment Headers

AHPOUT

AO_ERRNO Bank SW Error No C 10

AO_REFER Transaction Ref. C 18

AO_INPUTBY Payment Input By C 8

Nominal Transfer

ANOML

AX_NACNT Account The Nominal Account the value is to be transferredto. C 8 AX_NCNTR Cost Centre Cost Centre of the Nominal Account C 4 AX_SOURCE Source S=Sales, P=Purchase, W=Payroll, A=Cash Book C 1 AX_DATE Date Date it was posted to the Cash Book D 8 AX_VALUE Value Home Currency Amount N 12

AX_TREF Reference C 15

AX_COMMENT Comment C 40

AX_DONE Transferred Blank=Current, Y=Done, A=Advanced C 1 AX_FCURR Currency Currency Code of Nominal Account C 3

AX_FVALUE Foreign Value N 12

AX_FCRATE Exchange Rate Exchange Rate at time of Posting N 11

AX_FCMULT FC.Multiply L 1

AX_FCDEC FC.Decimal Places N 1

AX_SRCCO Source Company Source Company That This Analysis Line Has BeenPosted From C 1 AX_UNIQUE Unique ID Unique Identifier for Transaction C 8

ID Unique ID N 10

AX_PROJECT Nominal Project C 8

AX_JOB Nominal Department C 8

AX_JRNL Journal Number Journal Number N 5

Options

APARM

AP_PRNPOST Print Postings True if postings are to be printed as posted. L 1 AP_BACS BACS Software BACS software. eg: PAYBAKS or BAXPAK C 12 AP_NEXTREC Next Recurring Entry C 10 AP_KEEPTRN Retain Transactions N 2 AP_BKBAL Retain Bal's (Mths) N 3 AP_OUTPY Retain Paym's (Mths) N 3 AP_STENT Retain Stat's (Mths) N 3 AP_ALOG Retain A. Log (Mths) N 3 AP_BCVOLID BACS Vol. ID (Irish) Default BACS Volume ID for Volume Header Label(AIB and Bank

of Ireland) C 6

AP_BCAUTID BACS Auth.Id (Irish) Default BACS Authorisation ID for Volume HeaderLabel (AIB and Bank of Ireland)

6 C

Payee Names

APNAME

AN_PAYEE Payee C 8 "Payee Code may not be blank"

AN_NAME Name Mandatory C 30 "Payee Name may not be blank"

(8)

Name

Caption

Comment

Type Length

Rule

CASH BOOK

Payee Names

APNAME

AN_ADDR1 Address Line 1 C 30

AN_PSTCODE Post Code C 8

AN_TELENO Telephone C 20

AN_FAXNO Facsimile C 20

AN_CONTACT Contact C 20

AN_SORT Sort Code Must be present if AN_NUMBER entered C 8 "Sort code must either be empty or of the format 99-99-99"

AN_NUMBER Account No C 9

AN_KEY1 Key 1 Field Record search key - do not alter. C 5 AN_KEY2 Key 2 Field Record search key - do not alter. C 5 AN_KEY3 Key 3 Field Record search key - do not alter. C 5 AN_KEY4 Key 4 Field Record search key - do not alter. C 5

SQ_MEMO Memo M 10

AN_ATPYCD Bank Ref. Bank Reference No - Autopay code C 6

AN_BSREF C 18

AN_BSNAME C 18

Recurring Entries

ARHEAD

AE_ENTRY Entry Number C 10

AE_ACNT Account Nominal Account of the Bank Account C 8 AE_CNTR Cost Centre Cost Centre of the Bank Account C 4 AE_INPUTBY Input By The user who entered it. C 8 AE_TYPE Type of Entry 1=Nominal Payment2=Nominal Receipt3=Sales Refund4=Sales

Receipt5=Purchase Payment6=Purchase Refund N 1 AE_DESC Description 40 Character Comment M 10 AE_FREQ Frequency Recurring frequencyM=Months, W=Weeks, D=Days C 1 AE_EVERY Every Number of Days/Weeks/Months. N 3 AE_TOPOST Times to Post Times to Post. Number of times this entry is tooccur. N 3 AE_POSTED Times Posted Times Posted. The number of times this has beenposted. N 3

AE_NXTPOST Next Posting D 8

AE_LSTPOST Last Posting D 8

AE_VATANAL VAT Analysis True if VAT Analysis is required. L 1

SQ_MEMO Memo M 10

SQ_AMDATE Date Last Amendment D 8 SQ_AMTIME Time Last Amendment C 8 SQ_AMUSER User Last Amended C 8 AE_SRCCO Source Company Source Company That This Transaction Has Been To. C 1

(9)

Recurring Trans

ARLINE

AT_ENTRY Entry Number C 10

AT_LINE Line No N 6

AT_ACNT Account Nominal Account of Bank Account C 8 AT_CNTR Cost Centre Cost Centre of Bank Account C 4 AT_ACCOUNT Source Account Either Sales Account, Purchase Account or NominalAccount C 12 AT_CBTYPE Cashbook Type Must exist on ATYPE file C 2

AT_ENTREF Entry Reference C 15

AT_COMMENT Ref/Comment 40 Character Comment or Reference M 10

AT_REF2 Ref 2 C 10

AT_FCURR Currency Currency of Bank Account C 3

AT_FCDEC FC.Decimal Places N 1

AT_VALUE Amount Amount to be posted in currency of the account N 12 AT_DISC Discount Discount Amount if any. In currency of the account N 12 AT_DISCNL Disc Nominal Nominal A/C for the Discount Amount (if NominalPostings) C 12

AT_VATTYP VAT Type C 1

AT_VATCDE VAT Code C 1

AT_VATVAL VAT Value N 12

AT_REMIT Remit Print True if Remittance is required L 1 AT_CHQPRN Cheque Print True if automatic cheque is required L 1 AT_BACPRN BACS Print Flag True if payment is by BACS L 1

AT_PAYEE Payee Code C 8

AT_PAYNAME Payee Name C 35

AT_SORT Sort Code C 8

AT_NUMBER Account No C 9

AT_CCDNO C/Card Number C 16

AT_CCDDATE C/Card Expiry Date D 8

SQ_MEMO Memo M 10

SQ_AMDATE Date Last Amendment D 8 SQ_AMTIME Time Last Amendment C 8 SQ_AMUSER User Last Amended C 8

AT_ECB ECB Flag L 1

AT_ECBTYPE ECB Type C 1

AT_SRCCO Source Company ID C 1

AT_ATPYCD Bank Ref. C 6

AT_PROJECT Nominal Project C 8

AT_JOB Nominal Department C 8

AT_UNIQUE Unique ID Unique Identifier for Transaction C 8

ECB Script Lines

ASCRLN

AL_HOOK Hook C 2

(10)

Name

Caption

Comment

Type Length

Rule

CASH BOOK

ECB Script Lines

ASCRLN

AL_BKSOFT Software C 8

AL_LINE Script Line No. N 4

AL_FUNC Function Code C 8

AL_JUMPCD Jump Code List C 40

AL_JUMPTO Line No. to Jump To N 4

AL_EXITCD Exit Code List C 40

AL_MEMO Opera Commands M 10

ECB Scripts

ASCRPT

AC_HOOK Hook C 2 AC_BKSOFT Software C 8 AC_DESC Description C 30

ECB Statements

ASTAT

AS_ACNT Bank Account C 8

AS_CNTR Cost Centre C 4

AS_REF1 Entry Reference C 36

AS_TYPE Transaction Type C 1

AS_DATE Entry Date D 8

AS_VALUE Transaction Amount N 12

AS_REF2 Cheque Number C 10

AS_TRANTLA Transaction TLA C 3

AS_STATUS Entry Status C 1

AS_RECLNUM Reconciliation No. N 6

AS_ENTRY Entry Reference C 10

AS_CBTYPE Cashbook Type C 2

AS_STATNO Statement Number N 7

AS_LINENO Line Number N 6

AS_COMPLET Line Reconciled Flag L 1

AS_DLDATE Date of Download D 8

AS_DLTIME Time of Download C 8

AS_USER Download User C 8

AS_PAYID Payment ID - ECB N 20

AS_FCURR Transaction Currency C 3 AS_BRWPTR Reconcile Pointer C 2

Transactions Lines

ATRAN

AT_ACNT Account Nominal A/C of the Bank Account C 8 AT_CNTR Cost Centre Nominal C/C of the Bank Account C 4

AT_CBTYPE Cashbook Type C 2

AT_ENTRY Entry Number C 10

AT_INPUTBY Input By The user responsible for this entry C 8

(11)

Transactions Lines

ATRAN

AT_TYPE Type of Entry 1=Nominal Payment2=Nominal Receipt3=Sales Refund4=Sales Receipt5=Purchase Payment6=Purchase Refund7=Payroll Payment8=Bank Transfer

1 N

AT_PSTDATE Posting Date D 8

AT_SYSDATE System Date D 8

AT_TPERIOD This Period True if posted this period. L 1 AT_VALUE Value Amount in currency of the bank account N 12 AT_DISC Discount Discount. Amount in currency of the bank accountOnly for Sales &

Purchase Source. (SettlementDiscount of Receipt of Payment) N 12 AT_FCURR Currency Currency Code of Bank Account C 3 AT_FCEXCH Exchange Rate Exchange rate at time of Posting N 11

AT_FCMULT FC.Multiply L 1

AT_FCDEC FC.Decimal Places N 1

AT_ACCOUNT Source Account This can be the Sales Account, Nominal A/C &C/Centre, Purchase Account or Employee Numberdependant on the Source.

12 C AT_NAME Source Name To save looking up the necessary file the A/C nameof the relevant

A/C Number is store here. Foremployee Name the first character of the forename+ space + Surname is stored.

35 C

AT_COMMENT Comment Comment. Maximum of 40 Characters. M 10 AT_PAYEE Payee Code Payee Code. If this is a payment posted by Nominalpostings then

a payee code may be present whichrelates to the PNAME file.

8 C

AT_PAYNAME Payee Name C 35

AT_SORT Sort Code C 8

AT_NUMBER Account No C 9

AT_REMOVE Remove Flag True is transaction has been "Removed" from theCash Book L 1 AT_CHQPRN Cheque Print Flag True is a Cheque is to be printed L 1 AT_CHQLST Cheque List Flag True is this is to be printed on a Cheque List L 1 AT_BACPRN BACS Print Flag True is this is to print on a BACS List L 1 AT_CCDPRN C/Card Print Flag True is this is to print on a Credit Card List L 1

AT_CCDNO C/Card Number C 16

AT_CCDDATE C/Card Expiry Date Credit Card Expiry Date. Picture Format of MM/YY D 8 AT_PAYSLP Paying in Slip Ref Populated when the Paying in Slip is Printed N 6 AT_PYSPRN Paying in Slip Print True is this is to print on the Paying in Slip L 1 AT_CASH Cash Flag True is this receipt is Cash as opposed to acheque L 1 AT_REMIT Remit Flag True if Remit Required to be printed L 1 AT_UNIQUE Unique Id Unique Identifier for Transaction C 8

AT_POSTGRP Group Posting N 5

AT_CCAUTH C/Card Auth. Code Authorisation Code for Credit Cards C 8 AT_REFER Reference Entry Reference for Transaction C 15 AT_SRCCO Source Company Source Company That This Transaction Has BeenPosted To. C 1

AT_ECB ECB Flag L 1

AT_ECBTYPE ECB Type C 1

AT_ECBPAYD ECB Payment Val.Date D 8

(12)

Name

Caption

Comment

Type Length

Rule

CASH BOOK

Transactions Lines

ATRAN

AT_ATPYCD Bank Reference Bank Reference Number eg. AUTOPAY - NatWest C 6 AT_BSREF B/S Ref (BACS) Building Society reference (roll number) used forNL BACS

payments

18 C AT_BSNAME B/S Name (BACS) Building Society Name used for NL BACS payments C 18

ID Unique ID N 10

Cashbook Types

ATYPE

AY_CBTYPE Cashbook Code C 2 "Cashbook Type Code cannot be blank" AY_DESC Description C 15 "Description cannot be

left blank" AY_TYPE Type P=Payment, R=Receipt,T=TransferMay not be amended if

referenced in AENTRY file.

1 C AY_BANKLST Paying In Slip True if it is to appear on the Bank Paying in List(Only if AY_TYPE

is "R") L 1 AY_CRDTCRD Credit Card True if it is a Credit Card Receipt(Only if AY_TYPE is "R") L 1 AY_BATCHED Batched True will Group all items of this Cash Book Typepassed into the

Cash Book into one amount. eg: Allcheque receipts for one banking list will want toappear as one value in the Cask Book.

1 L

AY_ENTRY Next Entry No. Used for Identifying Individual Entries.Default to Code + 00000001.

10

C "Next Entry ID may not be blank"

Audit Log

AUDLOG

AL_TYPE Change Type C 10

AL_MODULE Module Id C 1

AL_PROCESS Changing Process C 60

AL_USER Changing User C 8

AL_DATE Change Date D 10

AL_TIME Change Time C 8

AL_TABLE Table C 10

AL_FIELD Field C 20

AL_KEY1 Key 1 C 60

AL_KEY2 Key 2 C 60

AL_OLDVAL Old Value C 60

AL_NEWVAL New Value C 60

AL_RECNO Record Number N 10

AL_VERSION Version Information C 40

AL_DTTIME Date Time T 8

(13)

Customer Products

LCPROD

LC_CNREF Stock Reference Stock Reference Code.Related to CNAME C 16 LC_SNACCT Cust. Account Sales Account Code.Related to SNAME C 8 LC_PRODREF Product Ref. Reference as defined within Customers System. C 30 LC_DESC Cust. Product Desc Customers description for this customer product. C 40 LC_BARCODE Cust. Bar Code Customers Bar Code for this Product. If differentto bar code held

on stock names file. C 15 LC_CUSREF Cust. Product Ref. Customers Product Reference Code. C 30 LC_CSWHAR Default Stk. Whse. Stock Warehouse to be used for this customerproduct. C 4 LC_PACSIZE Customer Pack Size Customer pack size to be used when receipt of EDISales Order.

Sales Orders maybe received in packsize and require to be multiplied by a pack sizefor internal order quantities. (This does noteffect Factoring). EDI Sales Orders received inunit quantites may require to be ordered in Packsize, this value will then divide into thequantity.

5 N

SQ_AMDATE Date Amended D 8

SQ_AMTIME Time Amended C 8

SQ_AMUSER User Amended C 8

SQ_MEMO Comments M 10

EDI Field Defaults

LDEFA

LF_MESSAGE Message Name EDI Message Name C 10 LF_LEVEL Level No File Level N 1 LF_SEGMENT Segment EDI Segment Identifier C 15 LF_ELEMENT Field Name EDI Field Name C 5 LF_DEFAULT Default Value EDI Field Default Value C 40 LF_FORCE Force Entry Force Entry of Default value into EDI File or fromEDI dependant

on Message Type

1 L LF_ACCOUNT Account Code Account Code for Customer or Supplier as indicatedin LF_TYPE C 8 LF_MEMO Advanced Default Advanced Default Memo M 10 LF_FALIAS Edition Level Alias N 1 LF_FNAME Edition Field Name C 10

SQ_CRDATE Creation Date D 8

SQ_CRTIME Creation Time C 8

SQ_CRUSER Creation User Name C 8

SQ_AMDATE Amendment Date D 8

SQ_AMTIME Amendment Time C 8

SQ_AMUSER Amendment User C 8

EDI Lookup Details

LDETL

LL_CODE Table Name EDI Table Name C 6 LL_ENTRY Table Entry Code Table Entry Code C 40

(14)

Name

Caption

Comment

Type Length

Rule

EDI

EDI Lookup Details

LDETL

LL_DESC Table Entry Desc. Entry Description C 40 LL_SPECIAL Special Use EDI Special Use field. C 20

EDI Document Default

LDOCS

LD_FEATURE EDI Feature Feature Code C 1 LD_ACCOUNT Account No. Account No. C 8 LD_DESC Document Description Document Description C 30 LD_MESSAGE EDI Message Name EDI Message Name to Use with this Feature. C 10 LD_REPDES EDI Report Design EDI Report Design Name C 8 LD_GENNO EDI Generation No. Last Generation Number used on thisFeature/Account. N 10 LD_IMPLOC Import Location Location of EDI enablers data for Import. C 60 LD_IMPFM Import Filemask Filemask for EDI Enablers Imported Data. Wildcardspermitted. C 12 LD_EXPLOC Export Location Export Location for EDI Module generated files. C 60 LD_EXPFM Export Filemask Export Filemask to use. C 12 LD_RDATE Revision Date Date last Updated. D 8 LD_SOOST SO Start Position Start Character within EDI Sales Order Number forOpera Customer

Order No. N 2

LD_SOOLN SO Length Length of Sales Order number from EDI File. N 2 LD_SOWHAR SO Default Warehouse Default Warehouse when Sales orders received. C 4 LD_SODATE SO Date Type Sales Orders created in Opera with (T)odays,(O)rder or (D)elivery

date.

1 C LD_SOPRICE SO Price Use Sales Order Price or Opera pricing. L 1 LD_INZINC Invoicing - Zero Include Zero Value Invoices from EDI messages L 1 LD_INMTYPE Invoicing-Mess. Type Invoicing Message Type - Used during testing C 10

SQ_CRUSER Creation User C 8

LD_ACTION Import File Action C 6 LD_ACTLOC Action File Location C 60

LD_ACTFM Action Filemask C 12

LD_OPTION Document Option Option specific by Document Type N 1 LD_ANALCDE Analysis Code Default Analysis code (Either Sales or Supplydependant on

Document) C 8

LD_OPTION2 Document Option 2 Option specific by Document Type N 1 LD_OPTION3 Sorting Product Opti N 1

EDI Field Elements

LELEM

LE_FIELD Field Name EDI Field Name C 5 LE_DESC Field Description EDI Field Description C 40 LE_LENGTH Field Length EDI Field Maximum Length N 3 LE_DPS Field Decimal Places If field type = (N)umeric then number of decimalplaces. N 1

(15)

EDI Field Elements

LELEM

LE_TYPE Field Type Field Type : (C)haracter, (N)umeric, (D)ate,(M)emo C 1 LE_VALID Field Validation Field Validation Table reference in LTABL. C 6 LE_MANCON Field Mandatory Field is generally (M)andatory or (C)onditional. C 1 LE_MEMO Field Uses Memo? Indicates whether this field is defined as a memoin the message

definition.

1 C

Headers

LIHEAD

LH_DOC Document Number C 10

LH_ACCOUNT Account C 8

LH_NAME Name C 30

LH_ADDR1 Address Line 1 C 30

LH_DATE Date D 8

LH_CUSTREF Customer Reference C 15 LH_DESP Despatched Method Despatch method code for delivery processpurposes. The code

from the customer record isused as a default.

3 C LH_DELAD1 Delivery Address L1 C 30 LH_DELAD2 Delivery Address L2 C 30 LH_DELAD3 Delivery Address L3 C 30 LH_DELAD4 Delivery Address L4 C 30 LH_DELAD5 Delivery Address L5 C 30

LH_DELADPC Post Code C 8

LH_IGNORE Ignore C 1

LH_SDIS1 Sett1 Discount N 5

LH_SDIS2 Sett2 Discount N 5

LH_ODISC Overall Disc. N 5

LH_NARR1 Narrative Line 1 C 75

LH_NARR2 Narrative Line 2 C 75

LH_PRODATE Proforma Date D 8

LH_QUODATE Quotation Date D 8

LH_CREDATE Creation Date D 8

LH_INVDATE Invoice Date D 8

LH_DELDATE Delivery Date D 8

LH_ORDDATE Order Date D 8

LH_PROFORM Proforma C 10

LH_QUOTAT Quotation C 10

LH_INVOICE Invoice C 10

LH_CREDIT Credit C 10

LH_DELIV Delivery C 10

LH_SORDER Sales Order C 10

LH_EXVAT Excluding VAT N 10

LH_VAT VAT N 10

(16)

Name

Caption

Comment

Type Length

Rule

EDI

Headers

LIHEAD

LH_SDAYS1 S1 Discount Days N 2

LH_SDAYS2 S2 Discount Days N 2

LH_SAMNT1 Sett.1 Disc. Amount N 10 LH_SAMNT2 Sett.2 Disc. Amount N 10 LH_OVERVAL Overall Disc. Value N 10

LH_POSTACC Post Account C 8

LH_LOC Warehouse Code C 4

LH_DOCSTAT Status Latest status of the document. Q=Quote,P=proforma, O=Order, D=Delivery Note, I=Invoice,C=Credit Note, U=Undefined (cumulative document).

1 C

LH_MEMO Memo Notepad relevant to the document, and is carriedwith the

document as it progresses. It may beedited at any time. M 10 LH_PRIORTY Priority If the document is an Order this field representsthe default priority

with which the order will beprocessed if there is insufficient stock tosatisfy it. The priority flag from the customerrecord is used as a default, but the field ismodifiable at order entry time.An entry of zero indicates top priority and stockis allocated immediately (on entry).

1 N

LH_REGION Region Region code for sales analysis purposes. The codefrom the

customer record is used as a default. C 3 LH_TERRTRY Territory Territory code for sales analysis purposes. Thecode from the

customer record is used as adefault.

3 C LH_ROUTE Route Route code for delivery process purposes. The codefrom the

customer record is used as a default.

3 C LH_DUE Due Date Default due date for the shipping of goods in theorder processing

system.

8 D LH_REVQUO Rev.Quotation Revision letter for Quote. A-Z. C 1 LH_REVPRO Rev.Proforma Revision letter for Pro-Forma. A-Z. C 1 LH_REVORD Rev.Order Revision letter for Order. A-Z. C 1 LH_REVDEL Rev.Delivery Note Revision letter for Delivery Note. A-Z. C 1 LH_REVINV Rev.Invoice Revision letter for Invoice. A-Z. C 1 LH_REVCRN Rev.Credit Note Revision letter for Credit Note. A-Z. C 1 LH_PRTSTAT Prn Status Print Status. E=Edited, P=Printed, N=Not Printed. C 1 LH_DCONTR CI Days Number of days for generation of contractinvoices. This field is

only active if withinadd/edit a cumulative document and repeatindicator is set to 'D'

3 N

LH_SCONTR Start Contract Inv. Start date for contract invoices. This field isonly used for the repetative invoice option whenthe repeat indicator is not N or Y.

8 D LH_ECONTR End Contract Inv. End date for contract invoices. This field is onlyused for the

repetative invoice option when therepeat indicator is not N or Y.

8 D LH_FCURR F.Currency This field indicates the currency of the document. C 3 LH_FCDEC F.Decimal Places This field indicates the number of decimal placesof the currency. N 1 LH_FCVAL Foreign Value This is the value of the document in foreignvaluation. C 11

(17)

Headers

LIHEAD

LH_FCRATE F.Exchange Rate This is the currency exchange rate at the time ofcreatation of the document.

11 N LH_FCVAT F.VAT This is the foreign valuation of the document VAT. C 11 LH_ADDPC Post Code Document Header Post Code. C 8 LH_DELT Delivery Terms Key to terms of delivery file C 3 LH_NTRN Nature of Transact. Key to nature of transaction file C 2 LH_MTRN Mode of Transport Key to mode of transport file C 1

LH_FCMULT F.Multiply L 1

LH_EDI EDI Processed Flag Has this Document been processed by EDI module. L 1 LH_EDITX EDI Transaction No. Used when document transmitted via EDI to trackthrough to EDI

Enabler/VAN/Recipient batch ofdocuments. Will be updated by EDI Module.

10 N

LH_EDIVN EDI Trans. Version Each time the EDI document is transmitted thiswill be incremented by 1. To indicate version oftransmission.

2 N LH_EDISTAT EDI Status Flag EDI Status Flag C 1 LH_EDIDATE EDI Translate Date EDI Translation Date D 8 LH_EDITIME EDI Translate Time Time Translated C 8 LH_EDIFILE EDI Translate File Filename allocated updated to. C 72 LH_EDIREF EDI Reference EDI Reference - Invoice No or Credit Note No. C 10 LH_UNIQUE Unique Reference Unique reference to match up with multipledocument references

for quotes and orders.

8 C

Transactions

LITRAN

LT_DOC Document Internal document number. C 10 LT_STOCK Stock Reference Stock reference. C 16 LT_DESC Description Item description. C 40 LT_ANAL Analysis Code Sales analysis code for this line. C 8 LT_QUAN Line Quantity Line quantity. N 9 LT_PRICE Item Price Item price. N 9 LT_DISC Disc. Item line discount (may be compound for chaineddiscounts). N 5 LT_VAT VAT Code Item's tax code. C 1 LT_LINEVAL Line Value Value for this line. N 9

LT_SDISC Sett. Disc L 1

LT_ODISC Overall Disc L 1

LT_STATUS Status Document line status. A=Added, D=Deleted,E=Edited. C 1 LT_DATE Date Date line entered. D 8 LT_RECNO Record Number Sequence within document. N 7 LT_EXVAT Goods Value Goods value excluding tax. N 9 LT_DISCVAL Disc. Amount Line discount amount. N 9 LT_SETT1 Sett.1 Disc. Line settlement discount level 1. N 9 LT_SETT2 Sett.2 Disc. Line settlement discount level 2. N 9 LT_OVERALL Overall Disc. Amount Overall discount amount. N 9 LT_VATVAL VAT Amount Tax amount. N 9 LT_VATPCT VAT Rate Tax percentage. N 5

(18)

Name

Caption

Comment

Type Length

Rule

EDI

Transactions

LITRAN

LT_MEMO Memo Chained discount description. M 10 LT_COST Cost Price Cost price per unit of this line. N 10 LT_PRIORTY Priority If the document is an Order this field is thepriority with which the

order line will beprocessed if there is insufficient stock tosatisfy it. The priority flag from the documentheader is used as a default, but the field ismodifiable at line entry time.An entry of zero indicates top priority and stockis allocated immediately (on entry).

1 N

LT_DUE Due Date Due date for the shipping of this line of goods inthe order processing system.The date from the document header is used as adefault, but is over-rideable.

8 D

LT_QTYALLC Quantity Alloc. For SOP only. This is the quantity of goodsallocated from stock to

this line. N 9

LT_DTEALLC Date Allocated For SOP only. This is the date of the LASTallocation of stock to this line.

8 D LT_QTYPICK Quantity Picked SOP For SOP only. This is the quantity of goods pickedfrom stock for

this line.

9 N LT_DTEPICK Date Picked SOP For SOP only. This is the date of the LAST pickingof stock for this

line.

8 D LT_QTYDELV Quantity Delivrd For SOP only. This is the quantity of goodsdelivered from stock for

this line. N 9

LT_DTEDELV Date Delivered For SOP only. This is the date of the LASTdelivery of stock for this line.

8 D LT_NUMDELV Delivery Note For SOP only. This is the number of the LASTdelivery note for this

line.

10 C LT_QTYINV Quantity Invcd For SOP only. This is the quantity of goodsinvoiced for this line. N 9 LT_DTEINV Date Invoiced For SOP only. This is the date of the LAST invoicefor this line. D 8 LT_NUMINV Invoice Number For SOP only. This is the number of the LASTinvoice for this line. C 10 LT_EXDATE Extra Date Extra date allowed (by option) to be tagged ontothe document

line. Useful in conjunction withIT_EXREF for certain types of business who need ajob date/ref on a document per line.

8 D

LT_EXREF Extra Reference Extra reference allowed (by option) to be taggedonto the document line. Useful in conjunction withIT_EXDATE for certain types of business who need ajob date/ref on a document per line.

20 C

LT_FCURR F.Currency This field indicates the currency of thetransaction, this field will be the same as IHEAD.It is stored here to make displaying and reportingeasier.

3 C

LT_FCRATE F.Rate This field indicates the exchange rate of thecurrency of the transaction, this field will bethe same as IHEAD. It is stored here to makedisplaying and reporting easier.

11 N

LT_FCDEC F.Decimal Places This field indicates the number of decimal placesfor the currency of the transaction, this fieldwill be the same as IHEAD. It is stored here tomake displaying and reporting easier.

1 N

LT_MARK Mark C 1

(19)

Transactions

LITRAN

LT_DELT Delivery Terms Key to terms of delivery file C 3 LT_NTRN Nature of Transact. Key to nature of transaction file C 1 LT_MTRN Mode of Transport Key to mode of transport file C 1 LT_COMCODE Commodity Code Commodity code. C 11 LT_SUPUNIT Supp. Units Supplementary Units For EC-VAT N 8 LT_CNTORIG Origin Country Country of origin of stock item. Required for EECVAT moule. C 2 LT_NTMASS Net Mass Per Unit Net Mass/Unit used for EC-VAT 'SD' Reporting. N 8 LT_VATTYP VAT Code Type VAT Type related to ZTAX Table (S,U or N). C 1

LT_FCMULT F.Multiply L 1

LT_JCSTDOC Job C 10

LT_JPHASE Phase C 3

LT_JCCODE Cost Code C 16

LT_JLINE Job Line C 10

LT_BTCHSER Batch/Serial Nos M 10

LT_FROMJC From Costing L 1

LT_QTYOVER Quantity Over Quantity over delivered N 9 LT_QTYORIG Original Quantity Original quantity N 9 LT_UNIQUE Unique Reference Unique Reference to match up multiple documentswith same

document no.

8 C LT_MASSUT Net Mass = Multiply Net Mass = Multiply , .T. = Multiply by quantity.F. = Net Mass is

total

1 L LT_CWCODE Line Warehouse Line Warehouse. C 4 IT_PJCODE Job Costing Code POP C 16

EDI Messages

LMESS

LM_MESSAGE Message Name EDI Message Name & Version C 10 LM_DESC Message Description EDI Message version C 40 LM_RDATE Message Revision Dte Message revision date. D 8 LM_SOURCE Source of Message Source of Message - Kewill C 10 LM_MTYPE Message Type Message Type (T)radacoms, (E)difact, (A)nsi X12 C 1 LM_XTYPE External Type External Type (I)nterbridge, (K)ewill or (M)essage C 1 LM_LEVEL1 Segments Level 1 Segments within Level 1 - 40 max. C 160 LM_LEVEL2 Segments Level 2 Segments within Level 2 - 40 max. C 160 LM_LEVEL3 Segments Level 3 Segments within Level 3 - 40 max. C 160 LM_LEVEL4 Segments Level 4 Segments within Level 4 - 40 max. C 160 LM_LEVEL5 Segments Level 5 Segments within Level 5 - 40 max. C 160 LM_LEVEL6 Segments Level 6 Segments within Level 6 - 40 max. C 160 LM_LEVEL7 Segments Level 7 Segments within Level 7 - 40 max. C 160 LM_LEVEL8 Segments Level 8 Segments within Level 8 - 40 max. C 160 LM_LEVEL9 Segments Level 9 Segments within Level 9 - 40 max. C 160 LM_LEVEL1T Level Heading - 1 Level Heading - 1 C 10 LM_LEVEL2T Level Heading - 2 Level Heading - 2 C 10 LM_LEVEL3T Level Heading - 3 Level Heading - 3 C 10 LM_LEVEL4T Level Heading - 4 Level Heading - 4 C 10

(20)

Name

Caption

Comment

Type Length

Rule

EDI

EDI Messages

LMESS

LM_LEVEL5T Level Heading - 5 Level Heading - 5 C 10 LM_LEVEL6T Level Heading - 6 Level Heading - 6 C 10 LM_LEVEL7T Level Heading - 7 Level Heading - 7 C 10 LM_LEVEL8T Level Heading - 8 Level Heading - 8 C 10 LM_LEVEL9T Level Heading - 9 Level Heading - 9 C 10 LM_LEVEL1V Version Level 1 Version Level 1 N 2 LM_LEVEL2V Version Level 2 Version Level 2 N 2 LM_LEVEL3V Version Level 3 Version Level 3 N 2 LM_LEVEL4V Version Level 4 Version Level 4 N 2 LM_LEVEL5V Version Level 5 Version Level 5 N 2 LM_LEVEL6V Version Level 6 Version Level 6 N 2 LM_LEVEL7V Version Level 7 Version Level 7 N 2 LM_LEVEL8V Version Level 8 Version Level 8 N 2 LM_LEVEL9V Version Level 9 Version Level 9 N 2 LM_LEVEL1F File Level 1 File Level 1 N 1 LM_LEVEL2F File Level 2 File Level 2 N 1 LM_LEVEL3F File Level 3 File Level 3 N 1 LM_LEVEL4F File Level 4 File Level 4 N 1 LM_LEVEL5F File Level 5 File Level 5 N 1 LM_LEVEL6F File Level 6 File Level 6 N 1 LM_LEVEL7F File Level 7 File Level 7 N 1 LM_LEVEL8F File Level 8 File Level 8 N 1 LM_LEVEL9F File Level 9 File Level 9 N 1 LM_FILLER Field Seperator Character which seperates fields in interpretedmessages. C 1 LM_FEATURE Feature Indicator EDI Feature Indicator C 1

LM_SLENGTH Segment Ident Length Segment Identifier Length, in raw or fixed formatthe length should

default to 4. However with theBASDA standard this could be 11. N 2 LM_LEVEL1G Segment Group Level1 Used in Edifact to Group Segments together. C 120 LM_LEVEL2G Segment Group Level2 C 120 LM_LEVEL3G Segment Group Level3 C 120 LM_LEVEL4G Segment Group Level4 C 120 LM_LEVEL5G Segment Group Level5 C 120 LM_LEVEL6G Segment Group Level6 C 120 LM_LEVEL7G Segment Group Level7 C 120 LM_LEVEL8G Segment Group Level8 C 120 LM_LEVEL9G Segment Group Level9 C 120 LM_LEVEL1S Segment Sequence L1 C 120

(21)

EDI Messages

LMESS

LM_LEVEL2S Segment Sequence L2 C 120 LM_LEVEL3S Segment Sequence L3 C 120 LM_LEVEL4S Segment Sequence L4 C 120 LM_LEVEL5S Segment Sequence L5 C 120 LM_LEVEL6S Segment Sequence L6 C 120 LM_LEVEL7S Segment Sequence L7 C 120 LM_LEVEL8S Segment Sequence L8 C 120 LM_LEVEL9S Segment Sequence L9 C 120

Purchase Orders

LPHEAD

LH_REF P/Order Reference Order Key C 10 LH_ACCOUNT Supplier Supplier Account C 8 LH_ODISC Overall Discount Overall Discount N 5 LH_CANCEL Cancelled Order Cancelled Indicator L 1 LH_CWCODE Intended Warehouse Warehouse Code C 4 LH_DELNAM Delivery Name Delivery Name C 40 LH_DELAD1 Delivery Address 1 Delivery Address C 30 LH_DELAD2 Delivery Address 2 C 30 LH_DELAD3 Delivery Address 3 C 30 LH_DELAD4 Delivery Address 4 C 30 LH_DELADPC Delivery Post Code Delivery Post Code C 8 LH_DELTELE Delivery Phone No. Delivery Telephone Number C 20 LH_DELFAX Delivery Fax Number Delivery Fax Number C 20 LH_CONTACT Contact Delivery Contact C 20 LH_NARR1 Narrative Line 1 Narrative Line 1 C 75 LH_NARR2 Narrative Line 2 Narrative Line 2 C 75 LH_PORDER Purchase Order Image Purchase Order Image M 10 LH_CURRCY Currency Currency for Document C 3 LH_EXRATE Exchange Rate Exchange Rate Used for Document N 11 LH_EXMULT Multiply Indicator Exchange Multiple Indicator L 1 LH_DPLACE Decimal Places Foriegn Decimal Places N 1 LH_TOTVAL Total Value Total Value for Order N 12

LH_TXTREP Text Image M 10

LH_BINREP Binary Image L 1

LH_REF2 Reference C 20

LH_EDI EDI Processed L 1

LH_EDITX EDI Transmission No N 10

(22)

Name

Caption

Comment

Type Length

Rule

EDI

Purchase Orders

LPHEAD

LH_EDIVN EDI Version No N 2

LH_EDISTAT EDI Status Current EDI Status C 1 LH_EDIDATE EDI Date Date Processed for EDItion D 8 LH_EDITIME EDI Time Time Processed in Edition C 8

LH_EDIFILE EDI Filename C 72

LH_EDIREF EDI Reference No C 10

LH_UNIQUE EDI Unique Ident C 8

LH_LEDGER Ledger a/c code C 8

Order Lines

LPLINE

LL_DHREF Requisition Document Requistion Key C 10 LL_DLLINE Requisition Line Requisition Line Number N 7 LL_DUREF Uncommitted Document Document Key C 10 LL_DULINE Document Line Document Line Number N 7 LL_DCREF Committed P/Order Purchase Order Key C 10 LL_DCLINE P/Order Line Purchase Order Line Number N 7 LL_ACCOUNT Supplier Account Supplier Account C 8 LL_LEDGER Ledger Account Ledger Account C 8 LL_SUPREF Supplier's Stock Ref Supplier's Reference C 16 LL_CNREF Stock Reference Stock Reference C 16 LL_DESC Description Description C 40 LL_EXTEND Extended Description M 10 LL_CWCODE Intended Warehouse Warehouse Code C 4 LL_JCSTDOC Job Costing Job Number Key C 10 LL_JPHASE Phase Costing Phase Key C 3 LL_JCCODE Cost Code Costing Code Code Key C 16 LL_JLINE Job Line Costing Job Line Number C 10 LL_REQQTY Quantity Required Required Quantity N 9 LL_RECQTY Quantity Received Received Quantity N 9 LL_INVQTY Quantity Invoiced Invoiced Quantity N 9 LL_REQQUA Quality Required Required Quality C 8 LL_RECQUA Quality Received Received Quality C 8 LL_REQDAT Date Required Required Date D 8 LL_RECDAT Date Received Received Date D 8 LL_QUOTED Quote Obtained Quoted Indicator L 1 LL_QUODAT Date Quote Obtained Date Quoted D 8 LL_PRICE Price Order Price N 12 LL_VALUE Value Order Value N 12 LL_DISCP Discount Percentage Discount Percent N 5 LL_DISCV Discounted Value Line Discounted Value N 12 LL_COMMIT Committed Line has been Committed to P/Order L 1 LL_ORDDSO Apply Overall Disc. Apply Overall Discount on Line L 1 LL_CMPLTD Order Completed Order Completed Indicator L 1 LL_CMPLTI Invoice Completed Invoice Completed Indicator L 1

(23)

Order Lines

LPLINE

LL_CURRCY Currency Currency for Order C 3 LL_DPLACE Decimal Places Foreign Decimal Places N 1 LL_CMPREFD Delivery Ref. Set Completed Delivery Reference C 17 LL_CMPREFI Invoice Ref. Set Completed Invoice Reference C 17

LL_SUPPCDE Supply Code C 8

LL_DELREF Delivery Reference Delivery Reference C 10 LL_COMMENT Comment for Receipt Receipt Comment C 35

LL_UNIQUE EDI Unique Ident C 8

EDI Segment Details

LSEGM

LS_MESSAGE EDI Message Name EDI Message Name C 10 LS_SEGMENT EDI Segment Ident. EDI Segment Identifier C 15 LS_DESC EDI Segment Desc. Segment General Description C 40 LS_SEGMAN Segment Mandatory Is segment (M)andatory or (C)onditional C 1 LS_FIELD Fields in Segment Upto 40 fields within Segment. 5 characters each. C 200 LS_LENGTH Field Lengths in Seg Upto 40 field lengths within segment. C 120 LS_DPS Field Decimal Places Decimal places for up to 40 fields. C 40 LS_TYPE Field Types Field Types for fields within segment. C 40 LS_MANCON Field Mandatory Fields within Segment (M)andatory or (C)onditional C 40 LS_VALID Field Validation Tbl Field Validation for 40 fields. C 240 LS_MEMO Field Uses Memo? Indicates whether this field is defined as a memoin the message

definition.

40 C

EDI P.Sheet Defaults

LSHEET

LP_REF Production Sheet Ref Production Sheet Reference for Report C 8 LP_FEATURE Feature Identifier EDI Feature Identifier C 1 LP_RDATE Report Revision Date Date report last revised D 8 LP_HEADING Report Heading Report Heading C 40 LP_ORDTYPE Report Order Type Order Type to Report On C 4 LP_LOCREPT Location Report? Location Report Flag (Product Report if .F.) C 1 LP_DBASIS Date Basis Report Date Basis - (O)rder Date,(D)eliveryDate,(T)ransmission

Date C 1

LP_EXPORT Export Type Export type - RPT Report, XLS Excel etc.. C 3 LP_FROM Report Start Number of days before Opera data for report tocommence0 =

Today

3 N LP_TO Report End Number of days after Opera data for report tocommence0 =

Today N 3

(24)

Name

Caption

Comment

Type Length

Rule

EDI

EDI P.Sheet Defaults

LSHEET

LP_MEMO Additional Rep Head. Additional Report Heading M 10 LP_CODES Report Codes Location or Product Codes used in Report M 10

EDI Lookup Table

LTABL

LB_TABLE Table Name EDI Table Name / Lookup C 6 LB_DESC Table Description EDI Table Name C 40

(25)

Assets

FASSET

FA_ASSET Asset C 8

FA_SUB Sub Asset C 4

FA_DESC Description C 40

FA_STATUS Status N = NewL = LiveS = DisposedF = Fully DepreciatedR = Renumbered

1 C

FA_CATG Category C 4

FA_DEPMETH Depr. Method 1 = Straight Line Percent2 = Straight Line Amount3 = Reducing Balance4 = Immediate Write Down5 = Manual

1 N

FA_ORGCOST Original Price N 13

FA_ORGDATE Date D 8

FA_RESDVAL Residual Value N 13

FA_ORGQTY Orig Qty N 8

FA_CURQTY Curr Qty N 8

FA_DEPRST Start Depr. D 8

FA_EXPLIFE Expected Life N 4

FA_REMLIFE Remaining Life N 4

FA_DEPRATE Depr. Rate N 13

FA_DEPRTD Accum. Depr. N 13

FA_CURNBV Current NBV. N 13

FA_CURCOST Capital Cost N 13

FA_NLCA Original Cost A/C C 12

FA_NLDT Depreciation TD A/C C 12

FA_NLDA Disposal Adj. A/C C 12

FA_NLDP Depreciation Account C 12 FA_PURTYPE Purchase Type C=Company OwnedF=Finance LeaseH=HP/Lease

PurchaseL=Operating LeaseO=Other

1 C FA_INTER Inter Group Purchase L 1 FA_CAPTLSE Capitalise Lease L 1

FA_SUPPLR Supplier Account C 8

FA_SUPPNAM Supplier Name C 30

FA_SUPPPO P Order No. C 10

FA_PODATE PO Date D 8

FA_POIMAGE PO Image M 10

FA_SUPPREF Supp Ref C 10

FA_SERIAL Serial Number C 30

FA_INSRCOM Insurance Company C 30 FA_INSRNO Insurance Policy No C 30

FA_INSRDAT Insr Renewal D 8

FA_INSRTEL Insurance Tel C 20

FA_INSRVAL Insurance Value N 13

FA_FCOMP Finance Company C 30

FA_FSTDT Start Date D 8

FA_FENDT End Date D 8

(26)

Name

Caption

Comment

Type Length

Rule

FIXED ASSETS

Assets

FASSET

FA_FREF Reference C 15

FA_FBNKACC Bank Account C 9

FA_FBNKDSC Bank Account Desc C 30

FA_FBNKSRT Bank Sort Code C 8

FA_FBNKNAM Bank Name C 30

FA_FOBLACC Obligation Nominal C 12 FA_FDDBSTO DDB SO Reference C 20

FA_FMEMO Additional Text M 10

FA_FGROSS Gross Earnings N 13

FA_FFREQTP Frequency Type DailyWeeklyMonthly C 9 FA_FFREQAM Frequency Amount N 3 FA_FNUMPAY Number of Payments N 3

FA_FPAYMNT Payment Amount N 13

FA_F1STPAY First Payment Amount N 13 FA_FLSTPAY Final Payment Amount N 13 FA_FNXTDUE Next Payment Date D 8 FA_FPAYMDE No. of Payments Made N 3 FA_FCHRGT Total Finance Charge N 13 FA_FOTHRT Total Other Costs N 13 FA_FOBLIG Remaining Obligation N 13 FA_FCHRGR Remaining Fin Charge N 13 FA_FOTHRR Remaining Other Cost N 13 FA_CTYPE Asset Details Type N 1

FA_DEP1ST First Per. Depr. L 1

FA_DEPLST Disposal Period Depr L 1 FA_DEPFULL Full Periods Depr. L 1 FA_DEPRUN Dep Run This Month N 3

FA_ADDPER Addition Period N 2

FA_ADDYEAR Addition Year N 4

FA_DEPPER Depr. Start Period N 2 FA_DEPYEAR Depr. Start Year N 4

FA_YRCOST Cost Year Start N 13

FA_YRQTY Qty. Year Start N 8

FA_YRNBV NBV. Year Start N 13

FA_DEPRTP Depr. TP N 13

FA_DEPRTY Depr. TY N 13

FA_DPDSTP Depr Disp TP N 13

FA_DPDSTY Depr Disp TY N 13

FA_DPDSTD Depr Disp TD N 13

FA_DSPVTP Disp TP Value N 13

FA_DSPVTY Disp TY Value N 13

FA_DSPVTD Disp TD Value N 13

FA_DETAILS Asset Details M 10

(27)

Assets

FASSET

FA_COMMENT Comments M 10

FA_DISPNO Disposal Number N 8

FA_OPDISP Disposal (Open Bal) L 1

SQ_MEMO Memo M 10

FA_INSR Insurance Code C 4

FA_OPDISTY Disposal TY Open Bal L 1

Asset Details

FASSEX

FE_ASSET Asset C 8

FE_SUB Sub Asset C 4

FE_NAME Name Land and Buildings C 30 FE_ADDR1 Address Line 1 Land and Buildings C 30 FE_ADDR2 Address Line 2 Land and Buildings C 30 FE_ADDR3 Address Line 3 Land and Buildings C 30 FE_ADDR4 Address Line 4 Land and Buildings C 30 FE_PSTCODE Post Code Land and Buildings C 8 FE_TEL Telephone Number Land and Buildings C 20 FE_FAXNO Facsimile Land and Buildings C 20 FE_CONTACT Contact Land and Buildings C 20 FE_LOCDEED Location of Deeds Land and Buildings C 20 FE_LEASET Terms of Lease Land and Buildings C 20 FE_LEASED Lease Expiry Date Land and Buildings D 8 FE_COLOUR Colour Motor Vehicles C 20 FE_ENGINE Engine Size Motor Vehicles C 4 FE_REGNUM Reg No Motor Vehicles C 7 FE_CHSNUM Chassis Number Motor Vehicles C 20 FE_FLTNUM Fleet Number Motor Vehicles C 10 FE_REGDATE Reg Date Motor Vehicles D 8 FE_RFLDATE Tax Due Date Motor Vehicles D 8 FE_MOTDATE MOT Date Motor Vehicles D 8 FE_TMILES Total Mileage Vehicle N 10 FE_BMILES Business Mileage Motor Vehicles N 10 FE_PMILES Private Mileage Motor Vehicles N 10 FE_HW Hardware Config. Computer C 40 FE_OS Operating System Computer C 40

FE_SCR Screen Computer C 40

FE_MOU Mouse Computer C 40

FE_OTH Other Computer C 40

(28)

Name

Caption

Comment

Type Length

Rule

FIXED ASSETS

Asset Details

FASSEX

FE_KEY Keyboard Computer C 40

FE_SW Software Computer C 40

FE_MAINTBY Maintained By Motor VehiclesEquipmentComputer C 30 FE_MNTTEL Maintenance Tel Motor VehiclesEquipmentComputer C 20 FE_WARDAT Warranty Expiry Date Motor VehiclesEquipmentComputer D 8 FE_MNTDAT Next Service Date Motor VehiclesEquipmentComputer D 8 FE_MNTCOST Service Cost To Date Motor VehiclesEquipmentComputer N 13 FE_REPVAL Replacement Value Land and BuildingsMotor VehiclesEquipmentComputer N 13 FE_REPDATE Replacement Date Motor VehiclesEquipmentComputer D 8 FE_MNTREF Maintenance Ref EquipmentComputer C 20 FE_MILESD Mileage Record Date D 8

Asset/Locations

FASSLC

FS_ASSET Asset C 8

FS_SUB Sub Asset C 4

FS_LOC Location C 4

FS_CNTR Cost Centre C 4

FS_QTY Quantity N 8

FS_NLDP Nominal Account C 12

FS_OLDNLDP Old Nominal Account C 12 FS_TMPWRK Temporary Work Area N 8

SQ_MEMO Memo M 10

FCATG

FC_CATG Category C 4 FC_DESC Description C 30 FC_BSGRP Bal.Sheet Group N 1

FC_CAGRP Category Group C 4

FC_DEPMETH Depreciation Method 1 = Straight Line Percent2 = Straight Line Amount3 = Reducing Balance4 = Immediate Write Down5 = Manual

1 N

FC_DEP1ST First Per. Depr. L 1

FC_DEPLST Disposal Period Depr L 1 FC_DEPFULL Full Periods Depr. L 1

FC_EXPLIFE Expected Life N 4

FC_DEPRATE Depr Rate N 13

FC_NLCA Original Cost A/C C 12

FC_NLDT Depreciation TD A/C C 12

FC_NLDA Disposal Adj. A/C C 12

FC_NLDP Depreciation Account C 12

SQ_MEMO Memo M 10

Category Groups

FGROUP

FG_CAGRP Category Group Code C 4 FG_DESC Description Date last Updated. D 30

(29)

Insurance Companies

FINSR

FI_INSR Insurance Code C 4

FI_NAME Company C 30

FI_ADDR1 Address Line 1 C 30

FI_PSTCODE Post Code C 8

FI_CONTACT Contact C 30

FI_TEL Telephone C 20

FI_FAXNO Facsimile C 20

FI_POLICY Policy Number C 30

FI_START Start Date D 8

FI_RENEWAL Renewal Date D 8

SQ_MEMO Memo M 10

Locations

FLOC

FL_LOC Location C 4

FL_NAME Name C 30

FL_ADDR1 Address Line 1 C 30

FL_PSTCODE Post Code C 8

FL_CONTACT Contact C 30

FL_TEL Telephone C 20

FL_FAXNO Facsimile C 20

FL_KEY1 Key 1 Field C 5

SQ_MEMO Memo M 10

Nominal Transfer

FNOML

FX_NACNT Account C 8 FX_NCNTR Cost Centre C 4 FX_DATE Date D 8 FX_VALUE Value N 13 FX_TREF Reference C 40 FX_COMMENT Comments C 40

FX_DONE Transferred Blank=Current, Y=Done, A=Advanced C 1 FX_BSACC Balance Sheet Accnt L 1

Options

FPARM

FP_PERIODS Periods N 2

(30)

Name

Caption

Comment

Type Length

Rule

FIXED ASSETS

Options

FPARM

FP_PER1 Period 01 D 8 FP_PER2 Period 02 D 8 FP_PER3 Period 03 D 8 FP_PER4 Period 04 D 8 FP_PER5 Period 05 D 8 FP_PER6 Period 06 D 8 FP_PER7 Period 07 D 8 FP_PER8 Period 08 D 8 FP_PER9 Period 09 D 8 FP_PER10 Period 10 D 8 FP_PER11 Period 11 D 8 FP_PER12 Period 12 D 8 FP_PER13 Period 13 D 8

FP_PERNO Current Period N 2

FP_YEAR Current Year N 4

FP_EOY End Of Year D 8

FP_KEEP Keep Assets Keep Disposed of Assets for Number of Years N 3 FP_NLPL Profit And Loss Susp C 12 FP_NLBS Balance Sheet Susp C 12 FP_NLVR Revaluation Reserve C 12 FP_NLVE Revaluation Expense C 12 FP_USECNTR Use Cost Centres If set to True Cost Centre facilities are enabled.This option is

ignored if linked to NL.

1 L FP_USELOC Use Locations If set to True Location facilities are enabled. L 1 FP_DPRWGHT Depr. Weighting Days If set to True then Depreciation is weighted onthe Days in a

period, rather than equally for eachperiod.

1 L FP_NLCOMP Nominal Company ID Blank if Current company? C 1 FP_AUTONUM Auto Start Number C 8 FP_UNLDISP Post Disp. to NL If set to True the NL is updated with DisposalJournals.This is only

available if linked to NL is set toTrue.

1 L FP_ACTIVE Delete Live Assets This Field Will Be Set True by the senior importand Will allow

LiveAssets to be deleted, this is to enable the systemto be tidied.At Dep Calc This WIll be Set to False

1 L FP_BSGRP1 Bal.Sheet Group 1 C 20 FP_BSGRP2 Bal.Sheet Group 2 C 20 FP_BSGRP3 Bal.Sheet Group 3 C 20 FP_BSGRP4 Bal.Sheet Group 4 C 20 FP_BSGRP5 Bal.Sheet Group 5 C 20 FP_BSGRP6 Bal.Sheet Group 6 C 20 FP_BSGRP7 Bal.Sheet Group 7 C 20

FP_DSTYP1 Disposal Type 1 C 15

(31)

Options

FPARM

FP_DSTYP10 Disposal Type 10 C 15 FP_DSTYP11 Disposal Type 11 C 15 FP_DSTYP12 Disposal Type 12 C 15 FP_CTYPE1 Asset Details Type 1 C 20 FP_CTYPE2 Asset Details Type 2 C 20 FP_CTYPE3 Asset Details Type 3 C 20 FP_CTYPE4 Asset Details Type 4 C 20 FP_CTYPE5 Asset Details Type 5 C 20 FP_CTYPE6 Asset Details Type 6 C 20 FP_CTYPE7 Asset Details Type 7 C 20 FP_CTYPE8 Asset Details Type 8 C 20 FP_CTYPE9 Asset Details Type 9 C 20

FP_DEPRUN Depreciation Run N 3

FP_TRNSFR Transfer Run For Per L 1

Transactions

FTRAN

FT_ASSET Asset S M A R T D O P E Y C 8 FT_SUB Sub Asset S M A R T D O P E Y C 4 FT_TYPE Type S M A R T D O P E YS = DisposalM = RenumberA = AdditionR =

RevalueT = TransferD = Depreciation AllocationO = OverrideP = Period DepreciationE = Depreciation Allocation on Disposed orPrevious Years AdjustmentY = Previous Years Adjustment

1 C FT_DATE Date S M A R T D O P E Y D 8 FT_PERIOD Period S M A R T D O P E Y N 2 FT_YEAR Year S M A R T D O P E Y N 4 FT_REF1 Comments S M A R T D O P E Y C 30 FT_COMMENT Ext. Comments S M A R T D O P E Y M 10 FT_INPUTBY Input By S M A R T D O P E Y C 8 FT_DEPRTY Depreciation TY S P Y D E R N 13

FT_QTY Quantity S T D E Y N 8

FT_DEPRTP Depreciation Value S D E Y P N 13

FT_OLDLOC Old Location S T C 4

FT_OLDCNTR Old Cost Centre S D E C 4 FT_DEPRTD Depreciation TD R E D S P Y N 13

FT_DISPNO Disp Number S N 8

FT_LOC Location T D E C 4

FT_CNTR Cost Centre T D E C 4

FT_OLDNLDP Old Nominal Account T C 12

(32)

Name

Caption

Comment

Type Length

Rule

FIXED ASSETS

Transactions

FTRAN

FT_NEWNLDP New Nominal Account T C 12 FT_NLDP Org Depr TP A/C D O S E Y C 12

FT_NASSET New Asset Code M C 8

FT_NSUB New Sub Code M C 4

FT_SEQ Seq No (Deprec) D E N 3

FT_LIFEUSE Life Used P N 4

FT_WRITDWN Written Down P L 1

FT_DEPRUN Depreciation Run D P E S N 3 FT_TRNSFR Transferred To NL D L 1

FT_CURCOST Current Cost D N 13

Transactions Extra

FTREX

FR_ASSET Asset S O R Y C 8

FR_SUB Sub Asset S O R Y C 4

FR_TYPE Type S O R YS = DisposalO = OverrideR = RevalueY = Previous Years Adjustment

1 C

FR_PERIOD Period S O R Y N 2

FR_YEAR Year S O R Y N 4

FR_DISPNO Disp Number S N 8

FR_DSPNAME Sold To S C 30

FR_REVALUE Revalue Amount TD R Y N 13 FR_BACKDAT Back Date Override R O L 1 FR_PSTJRNL Post Nominal Journal R Y L 1 FD_DEPFULL Dif Full Period Depr O L 1 FD_NLDA Dif Disp Adj A/C O C 12

FD_NLDP Dif Depr TP A/C O C 12

FD_NLCA Dif NL Cost A/C O C 12

FD_NLDT Dif Accm Depr A/C O C 12 FR_EXPLIFE Org Expected Life O N 4 FR_REMLIFE Org Remaining Life O N 4 FR_DEP1ST Org 1st Period Depr O L 1 FR_DEPLST Org Disp Month Depr O L 1

FR_CATG Org Category O C 4

FR_DEPFULL Org Full Per Depr O L 1 FR_NLCA Org Orig Cost A/C O C 12

FR_NLDT Org Depr TD A/C O C 12

FR_NLDA Org Disp Adj A/C O C 12 FR_NLALLOC Update Alloc Nominal O L 1

FD_CATG Dif Category O C 4

FD_DEPMETH Dif Depr Method O N 1 FD_EXPLIFE Dif Expected Life O N 4

FR_INTER Inter Group S L 1

FR_DEPRATE Org Depr Rate S R O Y N 13 FR_RESDVAL Org Residual Value S R O N 13

(33)

Transactions Extra

FTREX

FR_CURCOST Org Current Cost S R Y N 13 FR_CURNBV Org NBV Current S R Y N 13 FR_INSRVAL Org Insurance Value S R Y N 13 FR_PROLOSS Profit or Loss Amnt S N 13 FD_CURCOST Dif Current Cost S R Y N 13 FD_RESDVAL Dif Resd Value S R O N 13 FD_CURNBV Dif NBV Current S R Y N 13 FD_INSRVAL Dif Insurance Val C 13 FD_DEPRATE Dif Depr Rate S R O Y N 13 FD_DEPRTD Dif Depr TD S R Y N 13 FD_DEPRTY Dif Depr TY S R Y N 13 FD_REMLIFE Dif Remaining Life O N 4

FD_DEPRTP Dif Depr TP S N 13

FD_DEP1ST Dif First Per Depr O L 1 FR_DSPTYPE Disposal Type S C 15 FD_DEPLST Dif Disp Period Dep O L 1

FR_DSPINV Disp Inv No. S C 10

FR_DEPMETH Org Depr Method O N 1

FR_DSPINVD Disp Inv Date S D 8

FR_ORGQTY Org Quantity S N 8

FR_DSPVAL Disposal Proceeds S N 13 FR_DSPDEPR Depr. Disposal TD. S N 13

FR_DSPACC Sales Account S C 8

FR_DEPRST Org Start Depr. R D 8 FR_DEPPER Org Period Depr. R N 2 FR_DEPYEAR Org Year Depr. R N 4

FR_AUTHOR Authority S C 10

(34)

Name

Caption

Comment

Type Length

Rule

JOB COSTING

Batch Headers

JBHEAD

JG_BATCH Batch Batch number C 10

JG_DESC Description C 40

JG_STATUS Status Batch Status Values of1=Posted, 2=On Hold, 3=Unbalanced,

4=Cancelled N 1

JG_BTYPE Type Batch Type1=General, 2=Timesheets N 1 JG_HRSMIN Total Type Timesheet Value Type0 = Not yet processed1 = Units

(Hours/Minutes or Hours/Decimal)2 = Value

1 N JG_TOTAL Batch Total For Timesheet Batch Total Decimal Hours or WholeMinutes.

Parameter drivenFor Cost Batch Total of Values. Qty * Cost Units N 10

SQ_MEMO Memo M 10

SQ_CRTIME Time Creaded C 8

SQ_AMDATE Date Last Amendment D 8 SQ_AMTIME Time Last Amendment C 8 SQ_AMUSER User Last Amendment C 8

ID Unique ID N 10

Batch Details

JBLINE

JB_BATCH Batch Batch Number C 10

JB_CSTDOC Job Job number C 10

JB_PHASE Phase Phase number C 3 JB_LINE Line Number Job line number. C 10 JB_CCODE Cost Code Cost Code C 16 JB_RATE Cost Rate Cost Code N 3 JB_SCODE Sales Code Component quantity on work in progress C 8 JB_PCODE Purchase Code Purchase code. C 8 JB_CSTTYPE Cost Type Cost Type(Costs)1=Stock, 2=Labour, 3=Narrative, 4=Direct

Expense5,Recharged Expense, 6=Contractor,

7=Overhead(Revenue)11=Interim Billing, 12=Final Billing, 13=Retention(Write Up/Off)21=Write Up/Off

2 N

JB_DESC Description Job description, need not be set for jobs when theCode Code or stock issue with standarddescription. Is essential for goods or servicesprocessed through POP.

40 C

JB_TRTYPE Tran Type Transaction Type1 = B/fwd, 2 = Purchase, 3 = Labour, 4 =

GeneralCost, 5 = Revenue,6 = Commitment N 1 JB_TRDATE Date Date of transaction. D 8 JB_TRREF Reference Transaction Reference C 10 JB_QTY Quantity Quantity.Quantity is stored as defined in the Cost Code. N 10

JB_CSTUNIT Cost Cost. N 12

JB_VALUE Value Revenue or Cost Value. Stored with Sign -ve Costs N 10 JB_OHEAD Overhead Value Overhead value at time of posting.Will use Cost Code Overhead if

Option set toBackdate Overheads.

10 N JB_YEAR Year of Transaction Year of transaction. N 4

(35)

Batch Details

JBLINE

JB_PERIOD Period Period number of transaction. N 2 JB_WGRUP Payroll Group Payroll Group Code C 1 JB_WGPER Payroll Period Payroll pay period number N 2 JB_WGEMP Payroll Employee Payroll Employee C 8 JB_WGPAY Payroll Payment Payroll Payment Number C 4 JB_STREF Stock Reference Second reference. C 16 JB_STWH Stock Warehouse Stock Warehouse C 4 JB_SUBCNT Subcontractor Subcontractors Code C 10 JB_COMMENT Comment Transaction Comment C 30

SQ_MEMO Memo M 10

SQ_AMDATE Date Last Amendment D 8 SQ_AMTIME Time Last Amendment C 8 SQ_AMUSER User Last Amendment C 8

ID Unique ID N 10

Cost Codes

JCCODE

JA_CCODE Cost Code Cost Code Unique Field C 16 JA_DESC Description Cost Code Description C 40 JA_CSTTYPE Cost Type Cost Type(Costs)1=Stock, 2=Labour, 3=Narrative, 4=Direct

Expense5,Recharged Expense, 6=Contractor,

7=Overhead(Revenue)11=Interim Billing, 12=Final Billing, 13=Retention(Write Up/Off)21=Write Up/Off

2 N

JA_SCODE Sales Code Sales code from the SSALE file, may be left Blank. C 8 JA_PCODE Purchase Code Purchase code from the PPURCH file, may be leftblank C 8 JA_STREF Stock Reference Stock Reference. This may be left Blank, otherwiseif Stock Cost

type then may use the CNAME file theFactor information will be from the Stock Record .

16 C

JA_FACTOR Factor If is a factored item this field will contain theFactor for the Quantity, otherwise it will beempty.

6 N JA_FACTDPS Qty Decimals If Not a factored item you may specify the numberof decimal

places for the quantity field.otherwise this field will be empty

1 N JA_FACTDSC Unit Desc If JA_FACTDP is set to true this field willcontain the Factor

Description for the Quantity,otherwise it will be empty. C 8 JA_QTY Quantity Default quantity for Cost Code.May be a Factored Quantity or

Decimal. TheQuantity is stored in its base unit and will bedisplayed dependent on the factor. If linked toPayroll and a Labour Cost Type the PayrollParameters are used. The default sign will beMinus for "Cost" Cost Types and Positive for"Revenue" Cost Types. Entry will always bepositive.

10 N

(36)

Name

Caption

Comment

Type Length

Rule

JOB COSTING

Cost Codes

JCCODE

JA_USED Used in System If set to True the Cost Code has been used in someother file, this means the Type, Factored Item,Factor, and Factor Decimals may not be altered.The Reorganisation will recalculate the setting.

1 L

JA_WGVAL Payroll Transfer Transfer value to payroll L 1

SQ_MEMO Memo M 10

SQ_AMDATE Date Last Amendment D 8 SQ_AMTIME Time Last Amendment C 8 SQ_AMUSER User Last Amendment C 8 JA_EMPYEE Employee Employee C 8

Cost Code Rates

JCCOST

JO_CCODE Cost Code C 16

JO_RATE Cost Rate N 3

JO_WGPAY Payment Number Payroll Payment Number from the Payroll for LabourCost Types may not be blank.

4 C JO_EXTCOST Use Ext Cost? Indicates which Cost Unit to use 1 = Stock Selling Price

2 = Stock Cost Price 3 = Payroll Employee's Pay Rate 0 = Cost Unit as Defined for Cost Code

1 N

JO_CSTUNIT Cost N 12

JO_OHVAL Overhead Amount Overhead amount.If value exists then the Percentage is ignored. N 10 JO_OHMULT Overhead Multiply? If set to true then overhead values fortransactions with units will

be multiplied by theunits, this will not apply if the overhead is apercentage.

1 L

JO_OHPERC Overhead Percentage Percentage overhead,If JO_OHVAL value exists this field is empty. N 6

SQ_AMDATE Date Last Amendment D 8 SQ_AMTIME Time Last Amendment C 8 SQ_AMUSER user Last Amendment C 8

Job Headers

JCHEAD

JH_CSTDOC Job Job number. C 10

JH_PHASE Phase Phase. May be left Blank C 3 JH_CNTRACT Contract Contract number. May be left Blank else uses JCNTRfile C 8 JH_ACCOUNT Account Customer account, This may be left blank if nocustomer linked, for

example for internal Jobs.Otherwise it uses the SNAME file.Must be the same as Contract Details

8 C

JH_LEADER Proj Leader Project leader. From Peoples File May be LeftBlank.Default from Contract Details

10 C JH_PRJDEPT Department Department. C 4

(37)

Job Headers

JCHEAD

JH_DESC Description Job description.Default from Contract Details C 40 JH_CUSTREF Reference Customer reference number.Default from Contract Details C 16 JH_TERMS Contract Terms Details of terms of agreement.Default from Contract Details M 10

JH_RATE Cost Rate N 3

JH_STDATE Start Date Planned Start date.Default from Contract DetailsMust be => than

Contract Details D 8 JH_LENGTH Length in Days Expected Duration in days of Elapsed Time using 7days per

weekDefault from the Contract Details

4 N JH_XCMP Expected Completion Expected completion date. This will originally becalculated by the

start date plus the length indays. The date must be greater than the startdate.

8 D

JH_ASTDATE Actual Start Date Actual Date Started. D 8 JH_CMDATE Actual Completion Actual completion date.This field may not be set if any Jobs or

EstimatesDetail Lines are outstanding and not completed. Ifthis field has an entry it indicates the Job to beCompleted and may be cleared down in a reorganise.

8 D

JH_CCFIXED Cost Code Budgets If set to true the User is not allowed to AssignNew Cost Codes when Posting WIP, and Entry of CostCode Budgets. This is also dependent on the Optionto Allow Cost Code AdditionsAllow Additions Cost Code Fixed--- --- OFF

OFF = Post Additions Automatically OFF ON = Only Post Against Budgetted CostCodes ON OFF = Post Additions Automatically ON ON =

Post Against Budgetted Cost Codes

and Allow F5 to Assign New Cost Code

1 L

JH_OPNTYPE Open Item Type of job, True = open item. False = balanceforward, L 1 JH_BUDFIX Budgets Agreed If set to True the Budgets may not be amended, andall new

budget values must be entered in therevised budget field.

1 L JH_TTCSTBG Cost Budget Budget cost. Blank if Option for Header Budgets isnot set.Stored

as a negative number. Entered as positive.

11 N JH_TTCSTRV Rev. Cost Budget Revised budget cost. Blank if Option for HeaderBudgets is not

set.Stored as a negative number. Entered as positive. N 11

JH_TTCST Cost N 11

JH_TTCSTUP Upl. Cost N 11

JH_TTWOFBG Write Off Budget N 11 JH_TTWOFRV Rev.Write Off Budget N 11

JH_TTWOF Write Off N 11

JH_TTWOFUP Upl. Write Off N 11

JH_TTREVBG Revenue Budget Revenue budget. Blank if Option for Header Budgetsis not set. N 12 JH_TTREVRV Rev. Revenue Budget Revised revenue budget. Blank if Option for HeaderBudgets is not

set.

12 N

JH_TTREV Revenue N 12