Table: Purchase Order Options

Table: POOPT
View: PO0600
Record Length: 548

Flags: A R 

Keys: 1

Title Flags Fields
(Key) DUMMY

Fields: 65

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: (%-3C) %-3C-%-24C
FAX String*30 Fax Number Mask: (%-3C) %-3C-%-24C
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 Exp. Account Mask: %-45C
GLCSTACCT String*45 Default Cost Expense Account Mask: %-45C
DEFCOST Integer Default Cost List:6 entries
28 = Most Recent Cost
20 = Standard Cost
65 = Average Cost
31 = Last Unit Cost
8 = Vendor Cost
29 = Landed
NIPAYBACCT String*45 Non Inv. Payable Clr. Account Mask: %-45C
NONINVTOGL Boolean Post to Non-Inv. Pb. Clr. Acct. List:2 entries
0 = No
1 = Yes
EAPAYBACCT String*45 Exp. Add. Cost Pay. Clr. 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
RCPNEGINV Integer Allow Receipts In Negative Inventory List:2 entries
0 = No
1 = Yes

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).