| 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: %-30c |
| FAX |
4 |
String*30 |
Fax Number |
E A |
Mask: %-30c |
| 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
|
| ORDHIST |
8 |
Boolean |
Keep Purchase History |
E A |
List: 2 entries
|
| TRANHIST |
9 |
Boolean |
Keep Transaction History |
E A |
List: 2 entries
|
| KEEPSTAT |
10 |
Boolean |
Keep Statistics |
E A |
List: 2 entries
|
| EDITSTAT |
11 |
Boolean |
Edit Statistics |
E A |
List: 2 entries
|
| 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
|
| 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 Expense 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: 5 entries
| 28 | = | Most Recent Cost | | 20 | = | Standard Cost | | 65 | = | Average Cost | | 31 | = | Last Unit Cost | | 8 | = | Vendor Cost |
|
| NIPAYBACCT |
63 |
String*45 |
Non Inventory Payable Clearing Account |
E A |
Mask: %-45C |
| NONINVTOGL |
64 |
Boolean |
Post to Non-Inv. Pb. Clr. Acct. |
E A |
List: 2 entries
|
| EAPAYBACCT |
65 |
String*45 |
Exp. Additional Cost Payable Clearing Acct. |
E A |
Mask: %-45C |
| EXPADDTOGL |
66 |
Boolean |
Post to Exp. Add'l Cost Pb. Clr. Acct. |
E A |
List: 2 entries
|
| 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
|
| WARNNOITEM |
78 |
Boolean |
Warn if Non-Existing Item |
E A X |
List: 2 entries
|
| 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
|
| RQNMANAPPR |
82 |
Boolean |
Requisition Manual Approval |
E A |
List: 2 entries
|
| 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
|
| 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 |
|
|