View: Payables Clearing Audit

RotoID: PO0250
Table: POAAPC
Protocol: Flat
DLL:POAAPC

Keys: 3

Title Fields
Sequence Number DAYENDSEQ, HEADSEQ, LINESEQ, CURRENCY
Control Account CNTLACCT, FISCYEAR, FISCPERIOD, CURRENCY, TRANSDATE, DOCNUMBER
Document Link DOCZSEQ, DAYENDSEQ, HEADSEQ, LINESEQ, CURRENCY

Fields: 23

Field Index Type Title Attributes Presentation
DAYENDSEQ 1 BCD*10.0 Day End Number E A K R 
HEADSEQ 2 BCD*10.0 Header Sequence E A K R 
LINESEQ 3 BCD*10.0 Line Number E A K R 
CURRENCY 4 String*3 Currency E A K R  Mask: %-3N
CNTLACCT 5 String*6 Control Account E A 
GLCLEARING 6 String*45 Payables Clearing Account E A  Mask: %-45C
FISCYEAR 7 String*4 Fiscal Year E A  Mask: %4D
FISCPERIOD 8 Integer Fiscal Period E A 
TRANSDATE 9 Date Transaction Date E A 
DOCNUMBER 10 String*22 Document Number E A  Mask: %-22C
TRANSTYPE 11 Integer Transaction Type E A  List:7 entries
1 = Requisition
2 = Purchase Order
3 = Receipt
4 = Return
5 = Invoice
6 = Credit Note
7 = Debit Note
VENDOR 12 String*12 Vendor E A  Mask: %-12C
VENDORNAME 13 String*60 Name E A 
ITEMNO 14 String*24 Item Number E A  Mask: %-24C
SCEXTENDED 15 BCD*10.3 Extended Amount E A 
FCEXTENDED 16 BCD*10.3 Func. Extended Amount E A 
DTLTYPE 17 Integer Detail Type E A  List:2 entries
0 = Line
1 = Cost
ADDCOST 18 String*6 Additional Cost E A  Mask: %-6N
CONTRACT 19 String*16 Contract E A  Mask: %-16C
PROJECT 20 String*16 Project E A  Mask: %-16N
CCATEGORY 21 String*16 (Cost) Category E A  Mask: %-16N
DOCZSEQ 22 BCD*10.0 Document Link E A 
DATEBUS 23 Date Posting Date E A 

This page was generated on 2022-Aug-18

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).