Table: Purchase Order Postings

Table: POPORI
View: PO0621
Record length: 702
Flags: A R 

Keys: 2

Title  Flags  Fields

Master Key  PORISEQ
Receipts  D  PORHSEQ

Fields: 64

Field  Type  Title  Presentation 

PORISEQ  BCD*10.0  Purchase Order Sequence Key   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
OPERATION  Integer  Operation To Post   
DATE  Date  Date   
POSTDATE  Date  Last Posting Date   
ISCOMPLETE  Boolean  Completed  List: 2 entries
0=No
1=Yes
DTCOMPLETE  Date  Date Completed   
PORHSEQ  BCD*10.0  Purchase Order Sequence Key   
CURRENCY  String*3  Currency   
TAXCLASS1  Integer  Tax Class 1   
TAXCLASS2  Integer  Tax Class 2   
TAXCLASS3  Integer  Tax Class 3   
TAXCLASS4  Integer  Tax Class 4   
TAXCLASS5  Integer  Tax Class 5   
SCDOCTOTAL  BCD*10.3  Source Document Total   
ISPRINTED  Boolean  Printed  List: 2 entries
0=No
1=Yes
PONUMBER  String*22  Purchase Order Number   
LASTRECEIP  String*22  Last Receipt Number   
RCPCOUNT  Integer  Number of Posted Receipts   
DESCRIPTIO  String*60  Description   
REFERENCE  String*60  Reference   
HASRQNDATA  Boolean  Requisitions  List: 2 entries
0=No
1=Yes
PORTYPE  Integer  Purchase Order Type   
ONHOLD  Boolean  On Hold  List: 2 entries
0=No
1=Yes
RQNNUMBER  String*22  Requisition Number   
RQNHSEQ  BCD*10.0  Requisition Sequence Key   
VDCODE  String*12  Vendor   
VDNAME  String*60  Name   
RATE  BCD*8.7  Exchange Rate   
RATETYPE  String*2  Rate Type   
RATEDATE  Date  Rate Date   
RATEOPER  Integer  Rate Operation   
RATEOVER  Boolean  Rate Overridden  List: 2 entries
0=No
1=Yes
SCURNDECML  Integer  Decimal Places   
TAXGROUP  String*12  Tax Group   
TAXAUTH1  String*12  Tax Authority 1   
TAXAUTH2  String*12  Tax Authority 2   
TAXAUTH3  String*12  Tax Authority 3   
TAXAUTH4  String*12  Tax Authority 4   
TAXAUTH5  String*12  Tax Authority 5   
SCAMOUNT  BCD*10.3  Conversion Source Amount   
FCAMOUNT  BCD*10.3  Conversion Functional Amount   
HASJOB  Boolean  Job Related  List: 2 entries
0=No
1=Yes
AGENTTTYPE  Integer  Agent Transaction Type   
AGENTHSEQ  BCD*10.0  Agent Sequence Key   
AGTRANSNUM  BCD*10.0  Agent Dayend Transaction Number   
AGDOCNUM  String*22  Agent Document Number   
AGSRCDOC  String*22  Agent Source Document   
AGMULTIDOC  Boolean  Agent Is From Multiple Documents  List: 2 entries
0=No
1=Yes
AGDATE  Date  Agent Date   
AGFISCYEAR  String*4  Agent Fiscal Year   
AGFISCPER  Integer  Agent Fiscal Period   
AGDESC  String*60  Agent Description   
AGREF  String*60  Agent Reference   
TRCURRENCY  String*3  Tax Reporting Currency   
RATERC  BCD*8.7  Tax Reporting Exchange Rate   
RATETYPERC  String*2  Tax Reporting Rate Type   
RATEDATERC  Date  Tax Reporting Rate Date   
RATEOPERRC  Integer  Tax Reporting Rate Operation   
RATERCOVER  Boolean  Tax Reporting Rate Overridden  List: 2 entries
0=No
1=Yes
RCURNDECML  Integer  Tax Reporting Decimal Places   

This page was generated on 2008-May-01

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