Datafile Home \| KB Home \| Advanced Search

Sales Ledger Transactions (SLT)

Article Number: 1874 | Rating: Unrated | Last Updated: Thu, Jun 22, 2023 at 4:39 PM

Datafile Software

Sales Ledger Transactions (SLT)

Items Required

Item Name Type Size Description

1 TYPE X 1
2 DATE D
3 ACCOUNT X 10
4 REF X 6
6 AMOUNT K or L
7 TAX X 1
8 TAX-AMT K or L
10 TOTAL *
14 OUTSTANDING *
35 DEL-ADD-ACC X 10

Recommended Items to Add

Item Name Type Size Description
146 PODN-DATE D 8 ) Where proof-of-delivery is required, these fields hold
147 PODN-REF X 14 ) the date and a reference (type 1 records only)
148 FLGN N 4 File generation number of file in which sent
149 Ref Date & 0 For reference when picking transactions
150 XML? ? 1 Set to "Y” if to be sent by XML (copied from SLA)
151 XML-SENT D 8 Date XML file created
152 XML-ERROR N 4 Used in XML validation report. Is 0 if OK to send
153 SOP-INDEX X 15 Copied from SOP system; type 1/3 holds just the order ref,
type 9s hold the order and line number for lookup purposes
154 WORK-FLAG X 1 Used internally by ProFiler routines
155 DEL-ACC X 10 Holds code for the delivery point
156 DEL-NOTE X 6 Holds delivery note number (copied from SOH)
157 DEL-NOTE-DT D 8 Holds delivery note date (copied from SOH)

The following data items are assumed to be already present for date-time stamping
database records into the database, and have no particular bearing on XML.

158 ADDED-BY X 6
159 ADDED-ON D 8
160 ADDED-AT N 4

Custom Fields