Table: Purchase Order Options

Table: POOPT
View: PO0600
Record length: 546
Flags: A R 

Keys: 1

Title  Flags  Fields

(Key)  DUMMY

Fields: 64

Field  Type  Title  Presentation 

DUMMY  Integer  (key field)   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
NEXTSEQ  BCD*10.0  Next Control Sequence   
PHONE  String*30  Phone Number  Mask: %-30c
FAX  String*30  Fax Number  Mask: %-30c
CONTACT  String*60  Contact   
RATETYPE  String*2  Default Rate Type  Mask: %-2N
NOXITEMPER  Boolean  Allow Non-Inventory Items  List: 2 entries
0=No
1=Yes
ORDHIST  Boolean  Keep Purchase History  List: 2 entries
0=No
1=Yes
TRANHIST  Boolean  Keep Transaction History  List: 2 entries
0=No
1=Yes
KEEPSTAT  Boolean  Keep Statistics  List: 2 entries
0=No
1=Yes
EDITSTAT  Boolean  Edit Statistics  List: 2 entries
0=No
1=Yes
ORDYEAR  Integer  Accumulate History By  List: 2 entries
1=Calendar Year
2=Fiscal Year
ORDPERIOD  Integer  History Periods By  List: 10 entries
1=Weekly
2=Seven Days
3=Bi-weekly
4=Four Weeks
5=Monthly
6=Bi-monthly
7=Quarterly
8=Semi-annually
9=Annually
10=Fiscal Period
STATYEAR  Integer  Accumulate Statistics By  List: 2 entries
1=Calendar Year
2=Fiscal Year
STATPERIOD  Integer  Statistics Periods By  List: 10 entries
1=Weekly
2=Seven Days
3=Bi-weekly
4=Four Weeks
5=Monthly
6=Bi-monthly
7=Quarterly
8=Semi-annually
9=Annually
10=Fiscal Period
AGEDAYS1  Integer  Aging Period 1   
AGEDAYS2  Integer  Aging Period 2   
AGEDAYS3  Integer  Aging Period 3   
RQNNUMBERL  Integer  Requisition Length   
RQNPREFIXD  String*6  Requisition Prefix  Mask: %-6C
RQNBODYD  String*22  Requisition Number  Mask: %19D
PORNUMBERL  Integer  Purchase Order Length   
PORPREFIXD  String*6  Purchase Order Prefix  Mask: %-6C
PORBODYD  String*22  Purchase Order Number  Mask: %20D
RCPNUMBERL  Integer  Receipt Length   
RCPPREFIXD  String*6  Receipt Prefix  Mask: %-6C
RCPBODYD  String*22  Receipt Number  Mask: %19D
RETNUMBERL  Integer  Return Length   
RETPREFIXD  String*6  Return Prefix  Mask: %-6C
RETBODYD  String*22  Return Number  Mask: %19D
DEFTEMP  String*6  Default Template Code  Mask: %-6N
LGENDAYEND  BCD*10.0  Last G/L Day-End Sequence   
APPENDGL  Integer  Append to Existing G/L Batch  List: 3 entries
1=Adding to an Existing Batch
0=Creating a New Batch
2=Creating and Posting a New Batch
CONSOLGL  Integer  G/L Consolidation  List: 4 entries
1=Do Not Consolidate
9=Consolidate Transaction Details by Account
2=Consolidate by Account and Fiscal Period
3=Consolidate by Account, Fiscal Period, and Source
DEFERGL  Boolean  Generate G/L Batches On Demand  List: 2 entries
0=No
1=Yes
REFERENCGL  Integer  Contents of G/L Reference  List: 7 entries
1=Document Number
2=Source Code/Day End Number/Entry Number
3=Description
4=Reference
5=Vendor Number
6=Vendor Name
7=PO Number
DESCRIPTGL  Integer  Contents of G/L Description  List: 7 entries
1=Document Number
2=Source Code/Day End Number/Entry Number
3=Description
4=Reference
5=Vendor Number
6=Vendor Name
7=PO Number
GLACEXPENS  String*45  Default Inventory Expense Account  Mask: %-45C
GLCSTACCT  String*45  Default Cost Expense Account  Mask: %-45C
DEFCOST  Integer  Default Cost  List: 5 entries
28=Most Recent Cost
20=Standard Cost
65=Average Cost
31=Last Unit Cost
8=Vendor Cost
NIPAYBACCT  String*45  Non Inventory Payable Clearing Account  Mask: %-45C
NONINVTOGL  Boolean  Post to Non-Inv. Pb. Clr. Acct.  List: 2 entries
0=No
1=Yes
EAPAYBACCT  String*45  Exp. Additional Cost Payable Clearing Acct.  Mask: %-45C
EXPADDTOGL  Boolean  Post to Exp. Add'l Cost Pb. Clr. Acct.  List: 2 entries
0=No
1=Yes
DEFERAPPST  Integer  Deferred A/P Posting  List: 2 entries
0=During Day End Processing
1=On Request Using Create Batch Icon
SRCTYPEAD  String*2  P/O Adjustments  Mask: %-2N
SRCTYPECO  String*2  P/O Consolidation  Mask: %-2N
SRCTYPECR  String*2  P/O Credit Notes  Mask: %-2N
SRCTYPEDB  String*2  P/O Debit Notes  Mask: %-2N
SRCTYPEIN  String*2  P/O Invoices  Mask: %-2N
SRCTYPERA  String*2  P/O Receipt Adjustments  Mask: %-2N
SRCTYPERC  String*2  P/O Receipts  Mask: %-2N
SRCTYPERJ  String*2  P/O Return Adjustments  Mask: %-2N
SRCTYPERT  String*2  P/O Returns  Mask: %-2N
ALLOWNXVD  Boolean  Allow Non-Existing Vendors  List: 2 entries
0=No
1=Yes
WARNNOITEM  Boolean  Warn if Non-Existing Item  List: 2 entries
0=No
1=Yes
DATEBUSDFT  Integer  Default Posting Date  List: 2 entries
1=Document Date
2=Session Date
POSTRECENT  Integer  Recent/Last Cost Posting At  List: 2 entries
1=Receipt Costing
2=Invoice Costing
CPCOSTTOPO  Boolean  Default Copy Cost to Purchase Order  List: 2 entries
0=No
1=Yes
RQNMANAPPR  Boolean  Requisition Manual Approval  List: 2 entries
0=No
1=Yes

This page was generated on 2009-Nov-19

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