Table: Payables Clearing Audit

Table: POAAPC
View: PO0250
Record length: 330
Flags: A R 

Keys: 3

Title  Flags  Fields

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

Fields: 27

Field  Type  Title  Presentation 

DAYENDSEQ  BCD*10.0  Day End Number   
HEADSEQ  BCD*10.0  Header Sequence   
LINESEQ  BCD*10.0  Line Number   
CURRENCY  String*3  Currency  Mask: %-3N
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
CNTLACCT  String*6  Control Account   
GLCLEARING  String*45  Payables Clearing Account  Mask: %-45C
FISCYEAR  String*4  Fiscal Year  Mask: %4D
FISCPERIOD  Integer  Fiscal Period   
TRANSDATE  Date  Transaction Date   
DOCNUMBER  String*22  Document Number  Mask: %-22C
TRANSTYPE  Integer  Transaction Type  List: 7 entries
1=Requisition
2=Purchase Order
3=Receipt
4=Return
5=Invoice
6=Credit Note
7=Debit Note
VENDOR  String*12  Vendor  Mask: %-12C
VENDORNAME  String*60  Name   
ITEMNO  String*24  Item Number  Mask: %-24C
SCEXTENDED  BCD*10.3  Extended Amount   
FCEXTENDED  BCD*10.3  Func. Extended Amount   
DTLTYPE  Integer  Detail Type  List: 2 entries
0=Line
1=Cost
ADDCOST  String*6  Additional Cost  Mask: %-6N
CONTRACT  String*16  Contract  Mask: %-16C
PROJECT  String*16  Project  Mask: %-16N
CCATEGORY  String*16  (Cost) Category  Mask: %-16N
DOCZSEQ  BCD*10.0  Document Link   
DATEBUS  Date  Posting Date   

This page was generated on 2008-May-01

Copyright © 2001–2008 Sage Software, Inc. All rights reserved.