Purchase Ledger Transactions


Datafile Software

Purchase Ledger Transactions


Since purchase transactions are created by the PPO document processes and not directly
by the XL module, the only additions are for reference information that may be required.

Recommended Items to Add

Item Name Type Size Description

150 XML_TRANS? ? 1 Indicates it was created from an XML invoice
151 XML_XREF X 10 A reference (not the invoice number) from the XML file
152 XML_XREF-DT E 10 The date of the XML file (not invoice date)
153 XML_TAX-POINT E 10 From the XML file — Datafile tends not to use this
154 XML_PER N 4 Was required for Spicers
155 XML_CNNR X 10 Their credit note reference number (like order number)
156 XML_DESCR X 30 Generally from credit notes processed direct into the P/L

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 6
159 ADDED-ON D 8 2
160 ADDED-AT N 4 2
Custom Fields

Article ID: 1882
Created On: Tue, Jul 10, 2012 at 3:51 PM
Last Updated On: Thu, Jun 22, 2023 at 4:35 PM

Online URL: https://kb.datafile.co.uk/article/purchase-ledger-transactions-1882.html