View: Purchase Order Options

RotoID: PO0600
Table: POOPT
Protocol: Flat
DLL:POOPT

Keys: 1

Title Fields
(Key) DUMMY

Fields: 90

Field Index Type Title Attributes Presentation
DUMMY 1 Integer (key field) E A K R 
NEXTSEQ 2 BCD*10.0 Next Control Sequence A C 
PHONE 3 String*30 Phone Number E A  Mask: (%-3C) %-3C-%-24C
FAX 4 String*30 Fax Number E A  Mask: (%-3C) %-3C-%-24C
CONTACT 5 String*60 Contact E A 
RATETYPE 6 String*2 Default Rate Type E A  Mask: %-2N
NOXITEMPER 7 Boolean Allow Non-Inventory Items E A  List:2 entries
0 = No
1 = Yes
ORDHIST 8 Boolean Keep Purchase History E A  List:2 entries
0 = No
1 = Yes
TRANHIST 9 Boolean Keep Transaction History E A  List:2 entries
0 = No
1 = Yes
KEEPSTAT 10 Boolean Keep Statistics E A  List:2 entries
0 = No
1 = Yes
EDITSTAT 11 Boolean Edit Statistics E A  List:2 entries
0 = No
1 = Yes
ORDYEAR 12 Integer Accumulate History By E A P  List:2 entries
1 = Calendar Year
2 = Fiscal Year
ORDPERIOD 13 Integer History Periods By E A P  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 14 Integer Accumulate Statistics By E A P  List:2 entries
1 = Calendar Year
2 = Fiscal Year
STATPERIOD 15 Integer Statistics Periods By E A P  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 16 Integer Aging Period 1 E A 
AGEDAYS2 17 Integer Aging Period 2 E A 
AGEDAYS3 18 Integer Aging Period 3 E A 
RQNNUMBERL 19 Integer Requisition Length E A 
RQNPREFIXD 20 String*6 Requisition Prefix E A  Mask: %-6C
RQNBODYD 21 String*22 Requisition Number E A  Mask: %19D
PORNUMBERL 22 Integer Purchase Order Length E A 
PORPREFIXD 23 String*6 Purchase Order Prefix E A  Mask: %-6C
PORBODYD 24 String*22 Purchase Order Number E A  Mask: %20D
RCPNUMBERL 25 Integer Receipt Length E A 
RCPPREFIXD 26 String*6 Receipt Prefix E A  Mask: %-6C
RCPBODYD 27 String*22 Receipt Number E A  Mask: %19D
RETNUMBERL 28 Integer Return Length E A 
RETPREFIXD 29 String*6 Return Prefix E A  Mask: %-6C
RETBODYD 30 String*22 Return Number E A  Mask: %19D
DEFTEMP 31 String*6 Default Template Code E A  Mask: %-6N
LGENDAYEND 54 BCD*10.0 Last G/L Day-End Sequence E A 
APPENDGL 55 Integer Append to Existing G/L Batch E A  List:3 entries
1 = Adding to an Existing Batch
0 = Creating a New Batch
2 = Creating and Posting a New Batch
CONSOLGL 56 Integer G/L Consolidation E A  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 57 Boolean Generate G/L Batches On Demand E A  List:2 entries
0 = No
1 = Yes
REFERENCGL 58 Integer Contents of G/L Reference E A  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 59 Integer Contents of G/L Description E A  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 60 String*45 Default Inventory Exp. Account E A  Mask: %-45C
GLCSTACCT 61 String*45 Default Cost Expense Account E A  Mask: %-45C
DEFCOST 62 Integer Default Cost E A P  List:6 entries
28 = Most Recent Cost
20 = Standard Cost
65 = Average Cost
31 = Last Unit Cost
8 = Vendor Cost
29 = Landed
NIPAYBACCT 63 String*45 Non Inv. Payable Clr. Account E A  Mask: %-45C
NONINVTOGL 64 Boolean Post to Non-Inv. Pb. Clr. Acct. E A  List:2 entries
0 = No
1 = Yes
EAPAYBACCT 65 String*45 Exp. Add. Cost Pay. Clr. Acct. E A  Mask: %-45C
EXPADDTOGL 66 Boolean Post to Exp. Add'l Cost Pb. Clr. Acct. E A  List:2 entries
0 = No
1 = Yes
DEFERAPPST 67 Integer Deferred A/P Posting E A P X  List:2 entries
0 = During Day End Processing
1 = On Request Using Create Batch Icon
SRCTYPEAD 68 String*2 P/O Adjustments E A  Mask: %-2N
SRCTYPECO 69 String*2 P/O Consolidation E A  Mask: %-2N
SRCTYPECR 70 String*2 P/O Credit Notes E A  Mask: %-2N
SRCTYPEDB 71 String*2 P/O Debit Notes E A  Mask: %-2N
SRCTYPEIN 72 String*2 P/O Invoices E A  Mask: %-2N
SRCTYPERA 73 String*2 P/O Receipt Adjustments E A  Mask: %-2N
SRCTYPERC 74 String*2 P/O Receipts E A  Mask: %-2N
SRCTYPERJ 75 String*2 P/O Return Adjustments E A  Mask: %-2N
SRCTYPERT 76 String*2 P/O Returns E A  Mask: %-2N
ALLOWNXVD 77 Boolean Allow Non-Existing Vendors E A  List:2 entries
0 = No
1 = Yes
WARNNOITEM 78 Boolean Warn if Non-Existing Item E A X  List:2 entries
0 = No
1 = Yes
DATEBUSDFT 79 Integer Default Posting Date E A  List:2 entries
1 = Document Date
2 = Session Date
POSTRECENT 80 Integer Recent/Last Cost Posting At E A  List:2 entries
1 = Receipt Costing
2 = Invoice Costing
CPCOSTTOPO 81 Boolean Default Copy Cost to Purchase Order E A  List:2 entries
0 = No
1 = Yes
RQNMANAPPR 82 Boolean Requisition Manual Approval E A  List:2 entries
0 = No
1 = Yes
RCPNEGINV 83 Integer Allow Receipts In Negative Inventory E A  List:2 entries
0 = No
1 = Yes
RQNDEFAULT 101 String*22 Default Requisition A C 
RQNVALUE 102 String*22 Next Requisition A C 
PORDEFAULT 103 String*22 Default Purchase Order A C 
PORVALUE 104 String*22 Next Purchase Order A C 
RCPDEFAULT 105 String*22 Default Receipt A C 
RCPVALUE 106 String*22 Next Receipt A C 
RETDEFAULT 107 String*22 Default Return A C 
RETVALUE 108 String*22 Next Return A C 
ORDPRDTYP 109 Integer Historical Period Type A C 
ORDPRDLNG 110 Integer Historical Period Length A C 
ORDPRDS 111 Integer Historical Periods A C 
STATPRDTYP 112 Integer Statistical Period Type A C 
STATPRDLNG 113 Integer Statistical Period Length A C 
STATPRDS 114 Integer Statistical Periods A C 
DOCSETUP 115 Boolean Document Formats Set E A C X  List:2 entries
0 = No
1 = Yes
NEXTDAYEND 116 BCD*10.0 Next Day-End Sequence A C 
GLCSTACCTD 117 String*60 Cost Expense Acct. Desc. A C 
GLACEXPNSD 118 String*60 Inventory Expense. Acct. Desc. A C 
WEIGHTUNIT 119 String*10 Weight Unit of Measure
FRACTQTY 120 Boolean Fractional Quantities
HOMECURR 121 String*3 Home Currency A C 
DRIVERID 122 Integer Database Driver ID A C 
COSTDURING 123 Integer Cost During A  List:2 entries
1 = Day End Processing
2 = Posting
NIPAYBACCD 124 String*60 Non-Inv. Pbls. Clr. Acct. Desc. A C 
EAPAYBACCD 125 String*60 Exp. Add'l Cost Pbls. Clr. Acct. Desc. A C 
ACTION 126 Integer Action E A 
SLAUDURING 127 Integer Create Subledger/Audit During A  List:2 entries
1 = Day End Processing
2 = Posting
TPOSTACTN 128 Integer Transaction post/dep/cost A C  List:3 entries
11 = Quantity Only
12 = Cost Only
13 = Cost and Ledger
TAXGROUPD 129 String*60 Tax Group Description A C 

This page was generated on 2023-Aug-31

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