| 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
|
| 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 |
| OPT001ACTV |
32 |
Boolean |
Optional Field 2 Use |
E A |
List: 2 entries
|
| OPT001NAME |
33 |
String*10 |
Optional Field 2 Title |
E A |
|
| OPT001TBL |
34 |
String*8 |
Optional Field 2 Table |
E A |
Mask: %-8N |
| OPT002ACTV |
35 |
Boolean |
Optional Field 3 Use |
E A |
List: 2 entries
|
| OPT002NAME |
36 |
String*10 |
Optional Field 3 Title |
E A |
|
| OPT002TBL |
37 |
String*8 |
Optional Field 3 Table |
E A |
Mask: %-8N |
| OPT003ACTV |
38 |
Boolean |
Optional Field 4 Use |
E A |
List: 2 entries
|
| OPT003NAME |
39 |
String*10 |
Optional Field 4 Title |
E A |
|
| OPT003TBL |
40 |
String*8 |
Optional Field 4 Table |
E A |
Mask: %-8N |
| OPT004ACTV |
41 |
Boolean |
Optional Field 12 Use |
E A |
List: 2 entries
|
| OPT004NAME |
42 |
String*10 |
Optional Field 12 Title |
E A |
|
| OPT004TBL |
43 |
String*8 |
Optional Field 12 Table |
E A |
Mask: %-8N |
| OPT005ACTV |
44 |
Boolean |
Optional Field 15 Use |
E A |
List: 2 entries
|
| OPT005NAME |
45 |
String*10 |
Optional Field 15 Title |
E A |
|
| OPT005TBL |
46 |
String*8 |
Optional Field 15 Table |
E A |
Mask: %-8N |
| OPT006ACTV |
47 |
Boolean |
Optional Field 30 Use |
E A |
List: 2 entries
|
| OPT006NAME |
48 |
String*10 |
Optional Field 30 Title |
E A |
|
| OPT006TBL |
49 |
String*8 |
Optional Field 30 Table |
E A |
Mask: %-8N |
| OPTDATACTV |
50 |
Boolean |
Optional Date Field Use |
E A |
List: 2 entries
|
| OPTDATNAME |
51 |
String*10 |
Optional Date Field Title |
E A |
|
| OPTAMTACTV |
52 |
Boolean |
Optional Amount Field Use |
E A |
List: 2 entries
|
| OPTAMTNAME |
53 |
String*10 |
Optional Amount Field Title |
E A |
|
| LGENDAYEND |
54 |
BCD*10.0 |
Last G/L Day-End Sequence |
E A |
|
| APPENDGL |
55 |
Boolean |
Append to Existing G/L Batch |
E A |
List: 2 entries
|
| CONSOLGL |
56 |
Integer |
G/L Consolidation |
E A |
List: 3 entries
| 1 | = | Do Not Consolidate | | 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 Acct. |
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-Inventory Payables Clearing |
E A |
Mask: %-45C |
| NONINVTOGL |
64 |
Boolean |
|
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 |
|
|
| NIPAYBACCD |
124 |
String*60 |
Non-Inventory Payables Clearing |
A C |
|
|