1. Trans Mandatory - Stock Control Datafile Software Trans Mandatory - Stock Control TRANSACTION-TYPE X (1) Identifies the type of transaction TRANSACTION DATE D, E Holds the date the transaction was entered ‘as at’. STOCK CODE X (16) Holds the stock code the transact... Read More
2. Trans Mandatory - Batch Tracking Datafile Software Trans Mandatory - Batch Tracking TRANSACTION TYPE X (1) Holds the type of transaction. 1 – Sales Issue 3 – Purchase Delivery 4 – Goods Received 5 – Adjustment 7 – Transfer 8 – Stock Take Adjustment 9 – Asse... Read More
3. Trans Optional - Batch Tracking Datafile Software Trans Optional - Batch Tracking S/L P/L ACCOUNT X (10) Holds the sales or purchase account (as appropriate) that the transaction was generated for. S/L P/L ORDER REF X (16) Holds the order number that the transaction was genera... Read More
4. Audit Dept/Employee Pointers - Audit Employee/Trans Pointers - Audit Employee/P11 Pointers Datafile Software Audit Dept/Employee Pointers - Audit Employee/Trans Pointers - Audit Employee/P11 Pointers These options check and reset the relationship between the employee file and the department/transaction files.Note that the Transact... Read More
5. Cost Trans Item 1 Datafile Software Cost Trans Item 1 Data Item Type Description / Notes Job code X (10) Job code to which this job transaction refers Job record number Y (6) Record number of job in the job file Next Job cost rec Y (6) Record number of next job t... Read More
6. Cost Trans Items 2 Datafile Software Cost Trans Items 2 Data Item Type Description / Notes Emp def cost code X (10) Default cost code on employee record (when using lookup to employee record) Emp trade code T Trade code of the employee on this transaction Emp trad... Read More
7. Trans Mandatory - Database Profiles Datafile Software Trans Mandatory - Database Profiles Data Item Type Alternative Notes Transaction type Y(1) X(1) Holds the type of the transaction record.: 1 Invoice transaction 2 Payment transaction 3 Credit note transaction 4 Invoice ad... Read More
8. Trans Optional 1 - Database Profiles Datafile Software Trans Optional 1 - Database Profiles Data Item Type Alternative Notes Nominal code X (10) Y Only used in type 6–9 analysis records, plus types2 and 5 payments Nominal updated ?-type Nominal ledger changes this to Y as it post... Read More
9. Trans Optional 2 - Database Profiles Datafile Software Trans Optional 2 - Database Profiles Data Item Type Alternative Notes Job Reference X (10) Y Purchase Ledger Only. This item used to hold the job code if ledger linked to job costing. Job Code Analysis X (10) Y Purchase Ledger ... Read More
10. Trans Optional 3 - Database Profiles Datafile Software Trans Optional 3 - Database Profiles Data Item Type Alternative Notes EC Country X (3) Copied from accounts file; needed for EC reports EC Tax Reg X (15) Copied from accounts file; needed for EC reports EC Acquis Tax L K Purch... Read More