Business News
Stock Quotes
Oracle Corporatio:
29.11  0.00 
SAP AG ADS:
63.17  0.00 
Yahoo! Inc.:
15.92  0.00 
Google Inc.:
596.33  0.00 
Syndicate
Home arrow System Implementation arrow SunSystems 5 SQL Tables
SunSystems 5 SQL Tables PDF Print E-mail
User Rating: / 4
PoorBest 
Sun Documentation - System Implementation
Business Unit Create (BUC) is used to create the database tables for a new business unit. You identify the code you want to use as the business unit, and identify the database file group which must already exist. SunSystems creates all of the necessary database tables and files to support this new operating entity.
The Tables relating to a specific Business Unit are prefixed with the Business Unit Code (i.e. xxx_TableName, where xxx is the Business Unit Code).
Discuss in forum
For example, the Account Analysis Table for the PKP business unit will be: PKP_ACNT_ANL_CAT
Here is the list of tables created by this function:
Business Unit Create (BUC) is used to create the database tables for a new business unit. You identify the code you want to use as the business unit, and identify the database file group which must already exist. SunSystems creates all of the necessary database tables and files to support this new operating entity.
The Tables relating to a specific Business Unit are prefixed with the Business Unit Code (i.e. xxx_TableName, where xxx is the Business Unit Code).
For example, the Account Analysis Table for the PKP business unit will be: PKP_ACNT_ANL_CAT
Here is the list of tables created by this function:
Line Number

Table Name
Table Description



1
ACNT
Chart of Accounts
2
ACNT_ANL_CAT
Account Analysis
3
ACNT_BAL
Account Balance
4
ACNT_RECOG
Account Recognition Code
5
ADDR
Address
6
ADDR_ANL_CAT
Address Analysis
7
ADDR_TAX
Address Tax Id's
8
ALLOCN
Inventory Allocation
9
ALLOCN_IFACE
Report Interface- Account Allocations
10
ALLOCN_IND
Financials Allocation Indicator
11
ALT_INVY_UOM
Receipt- Actual Unit of Measure
12
ANL_BUS_ENT_DEFN
Analysis Mapping to Ledger
13
ANL_CAT
Analysis Dimension
14
ANL_CAT_BDGT_DEFN
Budget Control/Analysis
15
ANL_CAT_COST_CLASS
Cost Classification/Analysis
16
ANL_CODE
Analysis Code
17
ANL_ENT_DEFN
Analysis Structure
18
ANL_HRCHY_CODE
Analysis Hierarchy Code
19
ANL_HRCHY_LAB
Analysis Hierarchy Label
20
ANL_HRCHY_LINK
Analysis Hierarchy Link
21
ANL_SUBCAT
Analysis Sub-Dimension
22
APRVL_TABLE
Approval Table Analysis
23
APRVL_TABLE_LVL
Approval Level
24
ASSET
Fixed Asset
25
ASSET_ANL_CAT
Asset Analysis
26
ASSET_BDGT
Asset Budget
27
ASSET_NOTE
Asset Note
28
A_JNL_PSTG_AUDIT
Journal Posting Audit
29
A_SALFBAL
Ledger Balance Record
30
A_SALFLDG
Ledger
31
A_SALFLEX
Ledger Extension
32
BANK_DETAILS
Bank Details
33
BATCH
Batch
34
BATCH_ITEM_CHAR
Batch Item Characteristic
35
BDGT
Budget Balances
36
BDGT_ACNT_GRP
Budget Account Group
37
BUYING_GRP
Buying Group
38
B_JNL_PSTG_AUDIT
Journal Posting Audit Budget B
39
B_SALFBAL
Ledger Balance Budget B Record
40
B_SALFLDG
Budget B
41
B_SALFLEX
Budget B Extension
42
CHAR
Item or Storage Characteristic
43
CHARGE_INDEX
Landed Costing- Charge Index
44
CHARGE_INDEX_ELEMENT
Landed Costing- Charge Index Element
45
CHARGE_RULE
Landed Costing- Charge Rule
46
CONSUMPTION_LINE
Consumption Line
47
CONS_GRP
Sales Invoice Consolidation Rule Group
48
CONS_GRP_COL
Sales Invoice Consolidation Rule
49
CONTACT
Contact
50
CONV
Unit Conversion Rule
51
COSTING_ALLOCN
Alternative Costing Allocation Method
52
COSTING_ITEM_COSTS
Item Cost Batch Update
53
COSTING_KEY_INFO
Costing Batch Update Miscellaneous
54
COSTING_SETUP
Advanced Costing Definition
55
COSTING_UD_COSTS
User Defined Cost Batch Update
56
COSTING_WORK
Costing Work Table
57
COST_ANL
Costing Analysis
58
COST_COMBO
Costing Combination
59
COST_TYPE
Cost Type
60
CTRL_DSK_IFACE
Control Desk Interface
61
CTRL_DSK_LINK
Control Desk- Temporary Linkage
62
CURR
Currency
63
CURR_DAILY_RATE
Currency Daily Rate
64
CURR_PERD_RATE
Currency Period Rate
65
CUST
Customer
66
CUST_ACK_ADDR
Customer Acknowledgment Address
67
CUST_ADDR_CONTACT
Customer/Contact Address
68
CUST_ANL_CAT
Customer Analysis
69
CUST_BUYING_GRP
Customer/Buying Group
70
CUST_DELV_TO_ADDR
Customer/Delivery Address
71
CUST_DOC_FMT
Customer/Document Format
72
CUST_INV_ADDR
Customer/Invoice Address
73
CUST_TAX
Customer Tax Id's
74
C_JNL_PSTG_AUDIT
Journal Posting Audit Budget C
75
C_SALFBAL
Ledger Balance Budget C Record
76
C_SALFLDG
Budget C
77
C_SALFLEX
Budget C Extension
78
DEP_PSET
Depreciation Preset
79
DESP_LINE
Dispatch Line
80
DESP_LINE_ALLOCN
Dispatch Line Allocation
81
DESP_LINE_DOC_FMT
Dispatch Line/Document Format
82
DESP_LINE_LOG
Dispatch Line Key Mapping
83
DESP_LINE_VAL_ENTRY
Dispatch Line/Value Entry
84
DESP_NOTE
Dispatch Note Header
85
DOC_FMT_TAX_FILTER
Document Format/Tax Filter
86
DRILL_ASSOCIATES
Control Desk - Drill Control
87
DRILL_ASSOCIATES_TBL
Control Desk- Drill Type
88
D_JNL_PSTG_AUDIT
Journal Posting Audit Budget D
89
D_SALFBAL
Ledger Balance Budget D Record
90
D_SALFLDG
Budget D
91
D_SALFLEX
Budget D Extension
92
EDI_PROFILE
EDI Profile
93
EMP
Employee
94
EMP_ANL_CAT
Employee Analysis
95
EMP_ROLE
Employee/Role
96
ERR
Error Log
97
E_JNL_PSTG_AUDIT
Journal Posting Audit Budget E
98
E_SALFBAL
Ledger Balance Budget E Record
99
E_SALFLDG
Budget E
100
E_SALFLEX
Budget E Extension
101
FILTER_DEFN_CTRL
Filter
102
FILTER_DEFN_SORT
Filter/Sort Sequence
103
FILTER_DEFN_SQL
Filter/SQL
104
FILTER_SELECTION
Filter Selection
105
FILTER_SELECTION_LIST
Filter Selection/List
106
FML
Formula
107
FORMAT_CONS
Doc Format/Sales Invoice Consol'n Group
108
F_JNL_PSTG_AUDIT
Journal Posting Audit Budget F
109
F_SALFBAL
Ledger Balance Budget F Record
110
F_SALFLDG
Budget F
111
F_SALFLEX
Budget F Extension
112
GEN_INVY_CNT_WRK_1
General Inventory Count Work Table
113
GNRL_PURPOSE_CONV
Standard Unit Conversion/Unit Conv. Rule
114
GNRL_PURPOSE_ULAB
Standard Unit Conversion/Unit Label
115
GNRL_PURPOSE_UOM_CONV
Standard Unit Conversion
116
GRN
GRN Header
117
GRN_LINE
GRN Line
118
GRN_LINE_BATCH
GRN Line Batch
119
GRN_LINE_BATCH_ICHAR
GRN Line Batch/Item Characteristic
120
GRN_LINE_BATCH_MOL
GRN Line Batch/Movement Order Line
121
GRN_LINE_BATCH_PIL
GRN Line Batch/Purchase Invoice Line
122
GRN_LINE_BATCH_POL
GRN Line Batch/Purchase Order Line
123
GRN_LINE_BATCH_R
GRN Line Batch Revision
124
GRN_LINE_BATCH_REASON
GRN Line Batch/Reason
125
GRN_LINE_DOC_FMT
GRN Line/Document Format
126
GRN_LINE_DOC_FMT_R
GRN Line/Document Format Revision
127
GRN_LINE_MOL
GRN Line/Movement Order Line
128
GRN_LINE_MOL_VALENTRY
GRN Line/Movement Order Line/Value Entry
129
GRN_LINE_PIL
GRN Line/Purchase Invoice Line
130
GRN_LINE_PIL_VALENTRY
GRN Line/Purch Invoice Line/Value Entry
131
GRN_LINE_POL
GRN Line/Purchase Order Line
132
GRN_LINE_POL_VALENTRY
GRN Line/Purchase Order Line/Value Entry
133
GRN_LINE_R
GRN Line Revision
134
GRN_LINE_VAL_ENTRY
GRN Line/Value Entry
135
GRN_LINE_VAL_ENTRY_R
GRN Line/Value Entry Revision
136
GRN_LI_ENTRY
GRN/Ledger Posting Amendments
137
GRN_R
GRN Header Revision
138
G_JNL_PSTG_AUDIT
Journal Posting Audit Budget G
139
G_SALFBAL
Ledger Balance Budget G Record
140
G_SALFLDG
Budget G
141
G_SALFLEX
Budget G Extension
142
H_JNL_PSTG_AUDIT
Journal Posting Audit Budget H
143
H_SALFBAL
Ledger Balance Budget H Record
144
H_SALFLDG
Budget H
145
H_SALFLEX
Budget H Extension
146
INSPN_INSTR
Inspection Instruction
147
INVY_BUS_DEFN
Inventory Business Definition
148
INVY_CNT
Inventory Count Header
149
INVY_CNT_DEFN
Inventory Count Definition
150
INVY_CNT_LINE
Inventory Count Line
151
INVY_CNT_LINE_CONS
Inventory Count Line Consolidation
152
INVY_CNT_LINE_ITM_CHR
Inventory Count Line/Item Characteristic
153
INVY_CNT_LINE_SRL_NUM
Inventory Count Line/Serial Number
154
INVY_CNT_LOG
Inventory Count Log
155
INV_SCHED
Scheduled Invoice Header
156
INV_SCHED_LINE
Scheduled Invoice Line
157
ISS
Inventory Issue
158
ISS_ADJUST
Inventory Issue Archive Adjustment
159
ISS_COST
Inventory Issue Cost
160
ISS_ITEM_CHAR
Inventory Issue/Item Characteristic
161
ISS_UD_COST
Inventory Issue/User Defined Cost
162
ITEM
Item
163
ITEM_ACNT_RECOG
Item/Account Recognition
164
ITEM_ALT_SPRSESSN
Alternative or Superseding Item
165
ITEM_ANL_CAT
Item Analysis
166
ITEM_CHAR
Item Characteristic
167
ITEM_CHAR_DVA
Item Char/Discrete Alpha Value
168
ITEM_CHAR_DVN
Item Char/Discrete Numeric Value
169
ITEM_CHAR_GRP_DEFN
Item Characteristic Group
170
ITEM_CHAR_GRP_DFN_CHR
Item Characteristic Group Member
171
ITEM_CONV
Item/Unit Conversion Rule
172
ITEM_COST
Item Cost
173
ITEM_CUST
Item Customer
174
ITEM_CUST_CHAR_DVA
Item Customer Char/Discrete Alpha Value
175
ITEM_CUST_CHAR_DVN
Item Cust. Char/Discrete Numeric Value
176
ITEM_CUST_ITEM_CHAR
Item Customer/Item Characteristic
177
ITEM_SERIAL_FMT
Item/Serial Number Format
178
ITEM_STORE_CHAR
Item Storage Characteristic
179
ITEM_STORE_CHAR_DVA
Item Storage Char/Discrete Alpha Value
180
ITEM_STORE_CHAR_DVN
Item Storage Char/Discrete Num. Value
181
ITEM_SUPP
Item Supplier
182
ITEM_SUPP_CHAR_DVA
Item Supplier Char/Discrete Alpha Value
183
ITEM_SUPP_CHAR_DVN
Item Supplier Char/Discrete Num Value
184
ITEM_SUPP_ITEM_CHAR
Item Supplier/Item Characteristic
185
ITEM_UD_COST
Item/User Defined Cost
186
ITEM_ULAB
Item/Unit Label
187
I_JNL_PSTG_AUDIT
Journal Posting Audit Budget I
188
I_SALFBAL
Ledger Balance Budget I Record
189
I_SALFLDG
Budget I
190
I_SALFLEX
Budget I Extension
191
JNL_DEFN
Journal Definition
192
JNL_GRP_DEFN
Journal Type Group
193
JNL_GRP_DEFN_J_DEFN
Journal Type Group Member
194
J_JNL_PSTG_AUDIT
Journal Posting Audit Budget J
195
J_SALFBAL
Ledger Balance Budget J Record
196
J_SALFLDG
Budget J
197
J_SALFLEX
Budget J Extension
198
K_JNL_PSTG_AUDIT
Journal Posting Audit Budget K
199
K_SALFBAL
Ledger Balance Budget K Record
200
K_SALFLDG
Budget K
201
K_SALFLEX
Budget K Extension
202
LANDED_COST_LINE
Landed Cost Line
203
LANDED_VAL_ENTRY
Landed Cost/Value Entry
204
LAST_INVY_CNT
Last Inventory Count Date
205
LDG_DETAIL
Ledger Posting Details
206
LDG_DETAIL_LI_XREF
Ledger Posting Details/Cross Reference
207
LI_DEFN
Ledger Interface Header
208
LI_LANDED_COST
Ledger Posting/Landed Cost
209
LI_LINE
Ledger Interface Detail
210
LI_LINE_ANL_CAT
Ledger I'face Detail/Analysis Consol'n
211
LI_LINE_VLAB
Ledger Interface Detail/Value Label
212
LI_XREF
Ledger/Supply Chain Cross Reference
213
LOBJ
Linked Object
214
LOBJ_CONTACT
Linked Object/Contact
215
LOBJ_GRN
Linked Object/Goods Receipt Note
216
LOBJ_GRN_LINE
Linked Object/Goods Receipt Note Line
217
LOBJ_MO
Linked Object/Movement Order
218
LOBJ_MOL
Linked Object/Movement Order Line
219
LOBJ_PI
Linked Object/Purchase Invoice
220
LOBJ_PIL
Linked Object/Purchase Invoice Line
221
LOBJ_PO
Linked Object/Purchase Order
222
LOBJ_POL
Linked Object/Purchase Order Line
223
LOBJ_QL
Linked Object/Quotation Line
224
LOBJ_QUOTE
Linked Object/Quotation Header
225
LOBJ_SI
Linked Object/Sales Invoice
226
LOBJ_SIL
Linked Object/Sales Invoice Line
227
LOBJ_SO
Linked Object/Sales Order
228
LOBJ_SOL
Linked Object/Sales Order Line
229
LOCN
Location
230
LOCN_STORE_CHAR
Location or Storage Characteristic
231
MANU_FAC
Manufacturing Facility
232
MO
Movement Order Header
233
MOL
Movement Order Line
234
MOL_ANL_CANCEL_QTY
Movement Ord Line/Canc'd Quant Analysis
235
MOL_ANL_CANCEL_QTY_R
MO Line/Canc'd Quant Analysis Rev
236
MOL_ANL_CODE
Movement Order Line/Analysis
237
MOL_ANL_CODE_PSET
Movement Order Preset/Analysis
238
MOL_ANL_CODE_R
Movement Order Line/Analysis Revision
239
MOL_ANL_QTY
Movement Order Line/Analysis Quantity
240
MOL_ANL_QTY_R
Movement Order Line/Analysis Qty Rev
241
MOL_DOC_FMT
Movement Order Line/Document Format
242
MOL_DOC_FMT_R
Movement Order Line/Doc Format Rev
243
MOL_ITEM_CHAR
Movement Order Line/Item Characteristic
244
MOL_ITEM_CHAR_DVA
MO Line/Item Char/Discr Alpha Val
245
MOL_ITEM_CHAR_DVA_R
MO Line/Item Char/Discr Alpha Val Rev.
246
MOL_ITEM_CHAR_DVN
MO Line/Item Char/Discr Num Val
247
MOL_ITEM_CHAR_DVN_R
MO Line/Item Char/Discr Num Val Rev.
248
MOL_ITEM_CHAR_R
Movement Order Line/Item Char Rev
249
MOL_MISC_DOC_FMT
Movement Order Line/Misc Document Format
250
MOL_PSET
Movement Order Preset
251
MOL_PSET_MO_DEFN
Movem't Order Preset/Movem't Type Def'n
252
MOL_R
Movement Order Line Revision
253
MOL_STAGE
Movement Order Line/Stage History
254
MOL_STAGE_R
Movement Order Line/Stage History Rev
255
MOL_TOTAL_CANCL_QTY
Movement Ord Line/Total Cancelled Quant
256
MOL_TOTAL_CANCL_QTY_R
MO Line/Total Cancelled Quant Rev
257
MOL_VAL_ENTRY
Movement Order Line/Value Entry
258
MOL_VAL_ENTRY_PSET
Movement Order Preset/Value Entry
259
MOL_VAL_ENTRY_R
Movement Order Line/Value Entry Revision
260
MO_CTRL_VAL
Movement Order/Control Value
261
MO_DEFN
Movement Type Definition
262
MO_DEFN_STAGE
Movement Type Definition/Stage
263
MO_DEFN_VLAB
Movement Type Definition/Value Label
264
MO_GRP_DEFN
Movement Type Group
265
MO_GRP_DEFN_MO_DEFN
Movement Type Group Member
266
MO_LI_ENTRY
Movement Order/Ledger Posting Amendments
267
MO_LI_REV
Move. Type Def'n/Ledger I'face/Reversal
268
MO_R
Movement Order Header Revision
269
MO_SCHED_ORDER
Scheduled Movement Order
270
NUM_STREAM
Number Stream
271
NUM_STREAM_HDR
Number Stream Header
272
OPN
Operation
273
OPN_DETAIL
Operation Detail
274
OWN_CO
Business Unit Details
275
OWN_CO_ADDR
Business Unit/Address
276
PB
Price Book Page
277
PB_ANALYSIS
Price Book Page/Analysis
278
PB_CUML
Cumulative Price Book/Transaction
279
PB_DEFN
Price Book
280
PB_DEFN_ANALYSIS
Price Book/Analysis
281
PB_ENQUIRY
Price Book Inquiry Temporary Table
282
PB_LINE
Price Book Line
283
PB_PROMO_ITEM
Price Book/Promotional Item
284
PI
Purchase Invoice Header
285
PICK_LINE
Pick Line
286
PICK_LINE_ALLOCN
Pick Line/inventory Allocation
287
PICK_LINE_DOC_FMT
Pick Line/Document Format
288
PICK_LINE_LOG
Pick Line Key Mapping
289
PICK_LINE_VAL_ENTRY
Pick Line/Value Entry
290
PICK_LIST
Pick List
291
PIL
Purchase Invoice Line
292
PIL_ANL_CANCEL_QTY
PI Line/Cancelled Quant Analysis
293
PIL_ANL_CANCEL_QTY_R
PI Line/Cancelled Quant Analysis Rev
294
PIL_ANL_CODE
Purchase Invoice Line/Analysis
295
PIL_ANL_CODE_PSET
Purchase Invoice Preset/Analysis
296
PIL_ANL_CODE_R
Purchase Invoice Line/Analysis Revision
297
PIL_ANL_QTY
Purchase Invoice Line/Analysis Quantity
298
PIL_ANL_QTY_R
PI Line/Analysis Quantity Rev
299
PIL_APRVL_STAMP
Purchase Invoice Line/Approval Stamp
300
PIL_APRVL_STAMP_R
PI Line/Approval Stamp Revision
301
PIL_CONSUMED_BDGT
Purchase Invoice Line/Consumed Budget
302
PIL_CONSUMED_BDGT_R
PI Line/Consumed Budget Revision
303
PIL_DOC_FMT
Purchase Invoice Line/Document Format
304
PIL_DOC_FMT_R
Purchase Invoice Line/Doc Format Rev
305
PIL_ITEM_CHAR
Purchase Invoice Line/Item Characteristic
306
PIL_ITEM_CHAR_DVA
PI Line/Item Char/Discr Alpha Val
307
PIL_ITEM_CHAR_DVA_R
PI Line/Item Char/Discr Alpha Val Rev
308
PIL_ITEM_CHAR_DVN
PI Line/Item Char/Discr Num Value
309
PIL_ITEM_CHAR_DVN_R
PI Line/Item Char/Discr Num Value Rev
310
PIL_ITEM_CHAR_R
Purchase Invoice Line/Item Char Rev
311
PIL_MISC_DOC_FMT
Purchase Invoice Line/Misc Document
312
PIL_POL
Purchase Invoice Line/Purchase Ord Line
313
PIL_PSET
Purchase Invoice Preset
314
PIL_PSET_PURCH_DEFN
Purchase Invoice Preset/Purch Type Def'n
315
PIL_R
Purchase Invoice Line Revision
316
PIL_STAGE
Purchase Invoice Line/Stage History
317
PIL_STAGE_R
Purchase Invoice Line/Stage History Rev
318
PIL_TOTAL_CANCL_QTY
PI Line/Total Cancelled Quant
319
PIL_TOTAL_CANCL_QTY_R
PI Line/Total Cancelled Quant Rev
320
PIL_VAL_ENTRY
Purchase Invoice Line/Value Entry
321
PIL_VAL_ENTRY_PSET
Purchase Invoice Preset/Value Entry
322
PIL_VAL_ENTRY_R
Purchase Invoice Line/Value Entry Revision
323
PI_CTRL_VAL
Purchase Invoice/Control Value
324
PI_R
Purchase Invoice Header Revision
325
PI_SPLIT
Purchase Invoice Split
326
PO
Purchase Order Header
327
POL
Purchase Order Line
328
POL_ANL_CANCEL_QTY
PO Line/Analysis Cancelled Quant
329
POL_ANL_CANCEL_QTY_R
PO Line/Analysis Cancelled Quant Rev
330
POL_ANL_CODE
Purchase Order Line/Analysis
331
POL_ANL_CODE_PSET
Purchase Order Preset/Analysis
332
POL_ANL_CODE_R
Purchase Order Line/Analysis Revision
333
POL_ANL_QTY
Purchase Order Line/Analysis Quantity
334
POL_ANL_QTY_R
PO Line/Analysis Quantity Revision
335
POL_APRVL_STAMP
Purchase Order Line/Approval Stamp
336
POL_APRVL_STAMP_R
Purchase Order Line/Approval Stamp Revision
337
POL_CONSUMED_BDGT
Purchase Order Line/Consumed Budget
338
POL_CONSUMED_BDGT_R
Purchase Order Line/Consumed Budget Revision
339
POL_DOC_FMT
Purchase Order Line/Document Format
340
POL_DOC_FMT_R
Purchase Order Line/Document Format Revision
341
POL_ITEM_CHAR
Purchase Order Line/Item Characteristic
342
POL_ITEM_CHAR_DVA
PO Line/Item Char/Discr Alpha Val
343
POL_ITEM_CHAR_DVA_R
PO Line/Item Char/Discr Alpha Val Rev
344
POL_ITEM_CHAR_DVN
PO Line/Item Char/Discr Num Value
345
POL_ITEM_CHAR_DVN_R
PO Line/Item Char/Discr Num Value Rev
346
POL_ITEM_CHAR_R
Purchase Order Line/Item Char Revision
347
POL_MISC_DOC_FMT
Purchase Ord Line/Miscellaneous Document
348
POL_PSET
Purchase Order Preset
349
POL_PSET_PURCH_DEFN
Purchase Order Preset/Purch Type Def'n
350
POL_R
Purchase Order Line Revision
351
POL_STAGE
Purchase Order Line/Stage History
352
POL_STAGE_R
Purchase Order Line/Stage History Revision
353
POL_TOTAL_CANCL_QTY
PO Line/Total Cancelled Quant
354
POL_TOTAL_CANCL_QTY_R
PO Line/Total Cancelled Quant Rev
355
POL_VAL_ENTRY
Purchase Order Line/Value Entry
356
POL_VAL_ENTRY_PSET
Purchase Order Preset/Value Entry
357
POL_VAL_ENTRY_R
Purchase Order Line/Value Entry Revision
358
PO_CTRL_VAL
Purchase Order/Control Value
359
PO_R
Purchase Order Header Revision
360
PO_SCHED_ORDER
Scheduled Purchase Order
361
PROD_DEFN
Product Definition
362
PROD_GRP
Product Group
363
PROD_GRP_CONV
Product Group/Unit Conversion Rule
364
PROD_GRP_ULAB
Product Group Unit Label
365
PSTG_DETAIL
Ledger Import Pool Table/Detail
366
PSTG_ERR
Ledger Import/Error
367
PSTG_ERR_MSG
Ledger Import/Error Message
368
PSTG_HDR
Ledger Import Pool Table/Header
369
PSTG_STD_TEXT_LANG
Ledger Import Pool Table/Standard Text
370
PSTG_WRK_TBL
Ledger Import/Work Table
371
PURCH_BLNKT_CNTRCT
Purchase Blanket Contract
372
PURCH_BUS_DEFN
Purchase Business Definition
373
PURCH_DEFN
Purchase Type Definition
374
PURCH_DEFN_STAGE
Purchase Type Definition/Stage
375
PURCH_DEFN_VLAB
Purchase Type Definition/Value Label
376
PURCH_GRP_DEFN
Purchase Type Group
377
PURCH_GRP_DEFN_P_DEFN
Purchase Type Group Member
378
PURCH_ITEM_PRICE
Item Purchase Price
379
PURCH_LINE_LINK
Purchase Line Link
380
PURCH_LI_ENTRY
Purchasing/Ledger Posting Amendments
381
PURCH_LI_REV
Purch Type Def'n/Ledger I'face/Reversal
382
PYMT_SPLIT_TERM
Payment Split Term
383
PYMT_SPLIT_TERMS_GRP
Payment Split Terms Group
384
PYMT_TERM
Payment Term
385
PYMT_TERMS_GRP
Payment Terms Group
386
QL
Quotation Line
387
QL_ANL_CANCEL_QTY
Quotation Line/Canc'd Quantity Analysis
388
QL_ANL_CANCEL_QTY_R
QL/Canc'd Quantity Analysis Revision
389
QL_ANL_CODE
Quotation Line/Analysis
390
QL_ANL_CODE_PSET
Quotation Preset/Analysis
391
QL_ANL_CODE_R
Quotation Line/Analysis Revision
392
QL_ANL_QTY
Quotation Line/Analysis Quantity
393
QL_ANL_QTY_R
Quotation Line/Analysis Quantity Revision
394
QL_DOC_FMT
Quotation Line/Document Format
395
QL_DOC_FMT_R
Quotation Line/Document Format Revision
396
QL_ITEM_CHAR
Quotation Line/Item Characteristic
397
QL_ITEM_CHAR_DVA
QL/Item Char/Discrete Alpha Value
398
QL_ITEM_CHAR_DVA_R
QL/Item Char/Discrete Alpha Value Rev
399
QL_ITEM_CHAR_DVN
QL/Item Char/Discrete Num Value
400
QL_ITEM_CHAR_DVN_R
QL/Item Char/Discrete Num Value Rev
401
QL_ITEM_CHAR_R
Quotation Line/Item Characteristic Revision
402
QL_MISC_DOC_FMT
Quotation Line/Miscellaneous Document
403
QL_PSET
Quotation Preset
404
QL_PSET_Q_DEFN
Quotation Preset/Quotation Type Def'n
405
QL_R
Quotation Line Revision
406
QL_STAGE
Quotation Line/Stage History
407
QL_STAGE_R
Quotation Line/Stage History Revision
408
QL_TOTAL_CANCL_QTY
Quotation Line/Total Cancelled Quantity
409
QL_TOTAL_CANCL_QTY_R
QL/Total Cancelled Quantity Revision
410
QL_VAL_ENTRY
Quotation/Value Entry
411
QL_VAL_ENTRY_PSET
Quotation Preset/Value Entry
412
QL_VAL_ENTRY_R
Quotation/Value Entry Revision
413
QUOTE
Quotation Header
414
QUOTE_CTRL_VAL
Quotation/Control Value
415
QUOTE_R
Quotation Header Revision
416
Q_DEFN
Quotation Type Definition
417
Q_DEFN_STAGE
Quotation Type Definition/Stage
418
Q_DEFN_VLAB
Quotation Type Definition/Value Label
419
Q_GRP_DEFN
Quotation Type Group
420
Q_GRP_DEFN_Q_DEFN
Quotation Type Group Member
421
Q_LI_REV
Quot'n Type Def'n/Ledger I'face/Reversal
422
Q_SCHED_ORDER
Scheduled Quotation
423
RCPT
Inventory Receipt
424
RCPT_ADJUST
Inventory Receipt Archive Adjustment
425
RCPT_COST
Inventory Receipt Cost
426
RCPT_ITEM_CHAR
Inventory Receipt/Item Characteristic
427
RCPT_UD_COST
Inventory Receipt/User Defined Cost
428
REASON
Reason
429
ROLE
Role
430
ROUTE
Route
431
RSRCE
Resource - This table is for future use
432
RSRCE_ACNT_RECOG
Resource/Account Recognition
433
RSRCE_ANL_CAT
Resource Analysis - This is for future use
434
RSRCE_GRP
Resource Group
435
SALES_BLNKT_CNTRCT
Sales Blanket Contract
436
SALES_BUS_DEFN
Sales Business Definition
437
SALES_DEFN
Sales Type Definition
438
SALES_DEFN_STAGE
Sales Type Definition/Stage
439
SALES_DEFN_VLAB
Sales Type Definition/Value Label
440
SALES_GRP_DEFN
Sales Type Group
441
SALES_GRP_DFN_SLS_DFN
Sales Type Group Member
442
SALES_LINE_LINK
Sales Line Link
443
SALES_LI_ENTRY
Sales/Ledger Posting Amendments
444
SALES_LI_REV
Sales Type Def'n/Ledger I'face/Reversal
445
SALHARC
Ledger Archive
446
SAQFHLD
Held Journal
447
SELLING_ITEM_PRICE
Item Selling Price
448
SERIAL_NUM
Serial Number
449
SERIAL_NUM_FMT
Serial Number Format
450
SERIAL_NUM_HIST
Serial Number History
451
SI
Sales Invoice Header
452
SIL
Sales Invoice Line
453
SIL_ANL_CANCEL_QTY
SI Line/Cancelled Quant Analysis
454
SIL_ANL_CANCEL_QTY_R
SI Line/Cancelled Quant Analysis Rev
455
SIL_ANL_CODE
Sales Invoice Line/Analysis
456
SIL_ANL_CODE_PSET
Sales Invoice Preset/Analysis
457
SIL_ANL_CODE_R
Sales Invoice Line/Analysis Revision
458
SIL_ANL_QTY
Sales Invoice Line/Analysis Quantity
459
SIL_ANL_QTY_R
SI Line/Analysis Quantity Revision
460
SIL_DOC_FMT
Sales Invoice Line/Document Format
461
SIL_DOC_FMT_R
SI Line/Document Format Rev
462
SIL_ITEM_CHAR
Sales Invoice Line/Item Characteristic
463
SIL_ITEM_CHAR_DVA
SI Line/Item Char/Discr Alpha Val
464
SIL_ITEM_CHAR_DVA_R
SI Line/Item Char/Discr Alpha Val Rev
465
SIL_ITEM_CHAR_DVN
SI Line/Item Char/Discr Num Value
466
SIL_ITEM_CHAR_DVN_R
SI Line/Item Char/Discr Num Value Rev
467
SIL_ITEM_CHAR_R
Sales Invoice Line/Item Char Revision
468
SIL_LOG
Sales Invoice Line Key Mapping
469
SIL_MISC_DOC_FMT
Sales Invoice Line/Misc Document
470
SIL_PSET
Sales Invoice Preset
471
SIL_PSET_SALES_DEFN
Sales Invoice Preset/Sales Type Def'n
472
SIL_R
Sales Invoice Line Revision
473
SIL_SOL
Sales Invoice Line/Sales Order Line
474
SIL_STAGE
Sales Invoice Line/Stage History
475
SIL_STAGE_R
Sales Invoice Line/Stage History Revision
476
SIL_TOTAL_CANCL_QTY
Sales Invoice Line/Total Cancelled Quant
477
SIL_TOTAL_CANCL_QTY_R
SI Line/Total Cancelled Quant Rev
478
SIL_VAL_ENTRY
Sales Invoice Line/Value Entry
479
SIL_VAL_ENTRY_PSET
Sales Invoice Preset/Value Entry
480
SIL_VAL_ENTRY_R
Sales Invoice Line/Value Entry Revision
481
SI_CTRL_VAL
Sales Invoice/Control Value
482
SI_R
Sales Invoice Header Revision
483
SI_SPLIT
Sales Invoice Split
484
SO
Sales Order
485
SOL
Sales Order Line
486
SOL_ANL_CANCEL_QTY
SO Line/Canc'd Quantity Analysis
487
SOL_ANL_CANCEL_QTY_R
SO Line/Canc'd Quantity Analysis Rev
488
SOL_ANL_CODE
Sales Order Line/Analysis
489
SOL_ANL_CODE_PSET
Sales Order Preset/Analysis
490
SOL_ANL_CODE_R
Sales Order Line/Analysis Revision
491
SOL_ANL_QTY
Sales Order Line/Analysis Quantity
492
SOL_ANL_QTY_R
Sales Order Line/Analysis Qty Revision
493
SOL_DOC_FMT
Sales Order Line/Document Format
494
SOL_DOC_FMT_R
Sales Order Line/Doc Format Revision
495
SOL_ITEM_CHAR
Sales Order Line/Item Characteristic
496
SOL_ITEM_CHAR_DVA
SO Line/Item Char/Discr Alpha Val
497
SOL_ITEM_CHAR_DVA_R
SO Line/Item Char/Discr Alpha Val Rev
498
SOL_ITEM_CHAR_DVN
SO Line/Item Char/Discr Num Value
499
SOL_ITEM_CHAR_DVN_R
SO Line/Item Char/Discr Num Value Rev
500
SOL_ITEM_CHAR_R
Sales Order Line/Item Char Revision
501
SOL_MISC_DOC_FMT
Sales Order Line/Miscellaneous Document
502
SOL_PSET
Sales Order Preset
503
SOL_PSET_SALES_DEFN
Sales Order Preset/Sales Type Definition
504
SOL_R
Sales Order Line Revision
505
SOL_STAGE
Sales Order Line/Stage History
506
SOL_STAGE_R
Sales Order Line/Stage History Revision
507
SOL_TOTAL_CANCL_QTY
SO Line/Total Cancelled Quantity
508
SOL_TOTAL_CANCL_QTY_R
SO Line/Total Cancelled Quantity Rev
509
SOL_VAL_ENTRY
Sales Order Line/Value Entry
510
SOL_VAL_ENTRY_PSET
Sales Order Preset/Value Entry
511
SOL_VAL_ENTRY_R
Sales Order Line/Value Entry Revision
512
SO_CTRL_VAL
Sales Order/Control Value
513
SO_R
Sales Order Header Revision
514
SO_SCHED_ORDER
Scheduled Sales Order
515
SSRFMSC
Miscellaneous Static Data
516
STD_TEXT_ACNT
Account/Standard Text
517
STD_TEXT_ADDR
Address/Standard Text
518
STD_TEXT_ANL_CAT
Analysis Dimension/Standard Text
519
STD_TEXT_ANL_CODE
Analysis Code/Standard Text
520
STD_TEXT_APRVL
Approval Table/Standard Text
521
STD_TEXT_ASSET
Fixed Asset/Standard Text
522
STD_TEXT_BANK_DETAILS
Bank Details/Standard Text
523
STD_TEXT_BDGT
Budget Balances/Standard Text
524
STD_TEXT_CONTACT
Contact/Standard Text
525
STD_TEXT_CSTING_SETUP
Advanced Costing Def'n/Standard Text
526
STD_TEXT_CUST
Customer/Standard Text
527
STD_TEXT_DESP_LINE
Dispatch Line/Standard Text
528
STD_TEXT_DESP_NOTE
Dispatch Note Header/Standard Text
529
STD_TEXT_EMP
Employee/Standard Text
530
STD_TEXT_GRN
GRN Header/Standard Text
531
STD_TEXT_GRN_LINE
GRN Line/Standard Text
532
STD_TEXT_INSPN_INSTR
Inspection Instruction/Standard Text
533
STD_TEXT_INVY_B_DEFN
Inventory Business Def'n/Standard Text
534
STD_TEXT_ITEM
Item/Standard Text
535
STD_TEXT_ITEM_CUST
Item Customer/Standard Text
536
STD_TEXT_ITEM_SUPP
Item Supplier/Standard Text
537
STD_TEXT_LDG
Ledger/Standard Text
538
STD_TEXT_LDG_ARCHIVE
Ledger Archive Transaction/Standard Text
539
STD_TEXT_LOCN
Location/Standard Text
540
STD_TEXT_MO
Movement Order Header/Standard Text
541
STD_TEXT_MOL
Movement Order Line/Standard Text
542
STD_TEXT_PB_DEFN
Price Book/Standard Text
543
STD_TEXT_PI
Purchase Invoice Header/Standard Text
544
STD_TEXT_PIL
Purchase Invoice Line/Standard Text
545
STD_TEXT_PO
Purchase Order Header/Standard Text
546
STD_TEXT_POL
Purchase Order Line/Standard Text
547
STD_TEXT_PROD_GRP
Product Group/Standard Text
548
STD_TEXT_PURCH_B_DEFN
Purchase Business Def'n/Standard Text
549
STD_TEXT_PYMT_S_T_GRP
Payment Split Terms Group/Standard Text
550
STD_TEXT_PYMT_TRM_GRP
Payment Terms Group/Standard Text
551
STD_TEXT_QL
Quotation Line/Standard Text
552
STD_TEXT_QUOTE
Quotation Header/Standard Text
553
STD_TEXT_REASON
Reason/Standard Text
554
STD_TEXT_SALES_B_DEFN
Sales Business Definition/Standard Text
555
STD_TEXT_SI
Sales Invoice Header/Standard Text
556
STD_TEXT_SIL
Sales Invoice Line/Standard Text
557
STD_TEXT_SO
Sales Order Header/Standard Text
558
STD_TEXT_SOL
Sales Order Line/Standard Text
559
STD_TEXT_SUPP
Supplier/Standard Text
560
STD_TEXT_VLAB
Value Label/Standard Text
561
STD_TEXT_WHSE
Warehouse/Standard Text
562
STD_TEXT_ZONE
Zone/Standard Text
563
SUPP
Supplier
564
SUPP_ADDR_CONTACT
Supplier/Contact Address
565
SUPP_ANL_CAT
Supplier Analysis
566
SUPP_DOC_FMT
Supplier/Document Format
567
SUPP_ORDER_ADDR
Supplier/Order Address
568
SUPP_TAX
Supplier Tax Id's
569
TXN_REF_ANL
Transaction Reference/Analysis
570
TXN_REF_FMT
Transaction Reference Format
571
TXN_REF_FORMAT_EXT
Transaction Reference Format/Extension
572
UD_COST_DEFN
User Defined Cost Type
573
ULAB
Unit Label
574
VLAB
Value Label
575
WHSE
Warehouse
576
WHSE_ANL_CAT
Warehouse Analysis
577
WHSE_DOC_FMT
Warehouse/Document Format
578
WHSE_GRP
Warehouse Group
579
WHSE_GRP_WHSE
Warehouse Group Member
580
WHSE_STORE_CHAR
Warehouse/Storage Characteristic
581
WHSE_STORE_CHAR_DVA
W'house/Strge Char/Discrete Alpha Value
582
WHSE_STORE_CHAR_DVN
W'house/Strge Char/Discrete Num. Value
583
XFER_FORMAT
Transfer Format
584
ZONE
Zone
585
ZONE_STORE_CHAR
Zone/Storage Characteristic
586
ZONE_STORE_CHAR_DVA
Zone/Storage Char/Discrete Alpha Value
587
ZONE_STORE_CHAR_DVN
Zone/Storage Char/Discrete Numeric Value
Discuss in forum

Comments

Only registered users can write comments.
Please login or register.

New Forum Topics
Latest Articles
 
 
Popular Articles
Poll
Apart from Sun do you use other Infor products?
Yes, we use these Infor products:
Place your ads here: