The SAP file format follows closely, the format used by Statefleet.
NOTE – Changes from Statefleet structure are shown in BLUE
Accounts Receivable
AR General – Invoices and Customer Adjustments
Accounts Payable
AP General – Invoices and Vendor Adjustments
Batch Header Record:
'AP' Char(2) Batch Type
'B' Char(1) Record Type
'NNNNNN' Integer(6) Batch Number
'DDMMYYYY' Char(8) Batch Date
'HHMMSS' Char(6) Batch Time
(177) Filler
Header Record:
'AP' Char(2) Batch Type
'H' Char(1) Record Type
'0000000000' Char(10) insert prior to supplier number
'100000’ Char(6) Supplier Code (SAP Number)
'XXX...XXX' Char(20) Invoice Number
'XXX...XXX' Char(20) Original Invoice No (Not Used)
'DD/MM/YY' Char(8) Invoice Date
'NNNNNNNNNN.NN' Numeric(10.2) Total Invoice Amt (GST Inclusive)
'NNNNNNNNNN.NN' Numeric(10.2) GST Amt
(107) Filler
Detail Record:
'AP' Char(2) Batch Type
'I' Char(1) Record Type
'0000000000' Char(10) insert prior to supplier number
'100000’ Char(6) Supplier Code (SAP Number)
'XXX...XXX' Char(20) Invoice Number
'NNNNNNNNNN.NN' Numeric(10.2) Invoice Amt
'XXXX' Char(4) GST Code (See table fintref_d)
'NNNNNNNNNN.NN' Numeric(10.2) GST Amount
'XXX...XXX' Char(40) Detail Item Description
'XXX...XXX' Char(24) GL Account Number
'XXXXXXXXXX' Filler(10) Filler (For SFS is the Fleet Number)
'XXXXXXXXXX' Filler(10) Filler (For SFS this is Registration number)
Char(24) WBS Element
(23) Filler
Trailer Record:
'AP' Char(2) Batch Type
'T' Char(1) Record Type
'NNNNNN' Char(6) Batch Number
'NNNNNN' Integer(6) Total Number of Records
'NNNNNNNNNN.NN' Numeric(10.2) Total Batch Amount
(172) Filler