	Table	Prefix	Description
1	F4211	SD	Sales Order Detail File
2	F0101	AB	Address Book Master
3	F4101	IM	Item Master
4	F0911	GL	Account Ledger
5	F4311	PD	Purchase Order Detail File
6	F9671	SD	Software Update Detail Table
7	F4102	IB	Item Branch File
8	F0411	RP	Accounts Payable Ledger
9	F0006	MC	Business Unit Master
10	F41021	LI	Item Location File

	Table	Prefix	Description
1	F0011W	IC	F0011W - WF - Batch To Detail
2	F76AUI46	WF	CERG A/R -Work File - ARG - 03B - 76A
3	F4211	SD	Sales Order Detail File
4	F4101	IM	Item Master
5	F0101	AB	Address Book Master
6	F0911	GL	Account Ledger
7	F4102	IB	Item Branch File
8	F03B11	RP	Customer Ledger
9	F4111	IL	Item Ledger File
10	F4311	PD	Purchase Order Detail File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0006	MC	Business Unit Master
5	F0411	RP	Accounts Payable Ledger
6	F4211	SD	Sales Order Detail File
7	F42119	SD	Sales Order History File
8	F03012	AI	Customer Master by Line of Business
9	F0902	GB	Account Balances
10	F4801	WA	Work Order Master File

66 COLUMNS | 8 INDEXES | 812 | 13R | F48311 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
13R: Resource Assignments
1	812	F48311	RA	66	8	Resource Assignments	Files	13R: Resource Assignments	Business Data

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns. For Create statements, use Allow Null checkboxes and default values inputs to tailor query as required.

SELECT RATSKID, RAKCOO, RADCTO, RADOCO, RAOPSQ, RAOPSC, RAMCU, RAPRJM, RAMCUO, RATSKSTAT, RAASSN, RAIAVL, RAJBCD, RACMPE, RACMPC, RACMPV, RACPLVLFR, RACPLVLTO, RACMRQ, RARRTY, RARSCN, RADAP, RASCHSTTIME, RASCHENTIME, RASESD, RASEED, RASEST, RASEET, RAAHRS, RAASNP, RALPMD, RAPC, RADSC1, RADSC2, RAALTSKREF, RAASPRARF, RAAURCH1, RAAURCH2, RAAURCU1, RAAURCU2, RAAURDT1, RAAURDT2, RAAURMN1, RAAURMN2, RAAURST1, RAAURST2, RAAURST3, RAAURST4, RAAURST5, RAAURST6, RAAURST7, RAURCD, RAURDT, RAURAT, RAURAB, RAURRF, RAUSER, RAPID, RAJOBN, RAUPMJ, RAUPMT, RAANSA, RAANPA, RASHFT, RAWSCHP, RATSKID2 FROM F48311

TOP 812 | 13R | F48311 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	RATSKID	Task Unique Key ID	Numeric	Generic Edit	15	0	Allow NULL?
2	RAKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
3	RADCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
4	RADOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
5	RAOPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2	Allow NULL?
6	RAOPSC	Type Operation Code	String	UDC (30 OT)	2	0	Allow NULL?
7	RAMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
8	RAPRJM	Project Number	Numeric	Generic Edit	8	0	Allow NULL?
9	RAMCUO	Business Unit - Chargeout	String	Generic Edit	12	0	Allow NULL?
10	RATSKSTAT	Task Status	String	UDC (48 TK)	3	0	Allow NULL?
11	RAASSN	Assignment Type	String	UDC (48 TP)	10	0	Allow NULL?
12	RAIAVL	Availability Inclusion Flag	Character	Generic Edit	1	0	Allow NULL?
13	RAJBCD	Job Type (Craft) Code	String	UDC (06 G)	6	0	Allow NULL?
14	RACMPE	Competency Type	String	UDC (05 CY)	3	0	Allow NULL?
15	RACMPC	Competency Code	String	Generic Edit	10	0	Allow NULL?
16	RACMPV	Competency Level	Numeric	Generic Edit	6	3	Allow NULL?
17	RACPLVLFR	Competency Level From	Numeric	Generic Edit	6	3	Allow NULL?
18	RACPLVLTO	Competency Level To	Numeric	Generic Edit	6	3	Allow NULL?
19	RACMRQ	Rule Match Flag	Character	Generic Edit	1	0	Allow NULL?
20	RARRTY	Resource Type	String	UDC (05 RT)	2	0	Allow NULL?
21	RARSCN	Resource Number	Numeric	Generic Edit	8	0	Allow NULL?
22	RADAP	Date - Assigned to	Date	Generic Edit	6	0
23	RASCHSTTIME	Scheduled Start ANSI C UTC Time	Numeric	Generic Edit	15	0	Allow NULL?
24	RASCHENTIME	Scheduled End ANSI C UTC Time	Numeric	Generic Edit	15	0	Allow NULL?
25	RASESD	Date - Scheduled Start (Julian)	Date	Generic Edit	6	0
26	RASEED	Date - Scheduled End (Julian)	Date	Generic Edit	6	0
27	RASEST	Time - Scheduled Start (HH/MM/SS)	Numeric	Generic Edit	6	0	Allow NULL?
28	RASEET	Time - Scheduled End (HH/MM/SS)	Numeric	Generic Edit	6	0	Allow NULL?
29	RAAHRS	Assigned Hours	Numeric	Generic Edit	15	2	Allow NULL?
30	RAASNP	Percentage - Assignment	Numeric	Generic Edit	7	3	Allow NULL?
31	RALPMD	Load Profile Method	Character	UDC (48 LP)	1	0	Allow NULL?
32	RAPC	Percent Complete	Numeric	Generic Edit	5	0	Allow NULL?
33	RADSC1	Description	String	Generic Edit	30	0	Allow NULL?
34	RADSC2	Description - Line 2	String	Generic Edit	30	0	Allow NULL?
35	RAALTSKREF	Task Reference - Alternate	String	Generic Edit	25	0	Allow NULL?
36	RAASPRARF	Flag - TE Template Info Archive	Character	Generic Edit	1	0	Allow NULL?
37	RAAURCH1	User Reserved Char 01	Character	Generic Edit	1	0	Allow NULL?
38	RAAURCH2	User Reserved Char 02	Character	Generic Edit	1	0	Allow NULL?
39	RAAURCU1	User Reserved Currency 01	Numeric	Generic Edit	15	2	Allow NULL?
40	RAAURCU2	User Reserved Currency 02	Numeric	Generic Edit	15	2	Allow NULL?
41	RAAURDT1	User Reserved Date 01	Date	Generic Edit	6	0
42	RAAURDT2	User Reserved Date 02	Date	Generic Edit	6	0
43	RAAURMN1	User Reserved Numeric 01	Numeric	Generic Edit	15	4	Allow NULL?
44	RAAURMN2	User Reserved Numeric 02	Numeric	Generic Edit	15	4	Allow NULL?
45	RAAURST1	User Reserved String 01	String	Generic Edit	5	0	Allow NULL?
46	RAAURST2	User Reserved String 02	String	Generic Edit	5	0	Allow NULL?
47	RAAURST3	User Reserved String 03	String	Generic Edit	15	0	Allow NULL?
48	RAAURST4	User Reserved String 04	String	Generic Edit	15	0	Allow NULL?
49	RAAURST5	User Reserved String 05	String	Generic Edit	15	0	Allow NULL?
50	RAAURST6	User Reserved String 06	String	Generic Edit	15	0	Allow NULL?
51	RAAURST7	User Reserved String 07	String	Generic Edit	30	0	Allow NULL?
52	RAURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
53	RAURDT	User Reserved Date	Date	Generic Edit	6	0
54	RAURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
55	RAURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
56	RAURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
57	RAUSER	User ID	String	Generic Edit	10	0	Allow NULL?
58	RAPID	Program ID	String	Generic Edit	10	0	Allow NULL?
59	RAJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
60	RAUPMJ	Date - Updated	Date	Generic Edit	6	0
61	RAUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
62	RAANSA	Address Number - Manager	Numeric	Generic Edit	8	0	Allow NULL?
63	RAANPA	Supervisor	Numeric	Generic Edit	8	0	Allow NULL?
64	RASHFT	Shift Code	Character	UDC (06 SH)	1	0	Allow NULL?
65	RAWSCHP	Maintenance Scheduling Status	Character	UDC (48 WS)	1	0	Allow NULL?
66	RATSKID2	Related Task Unique Key	Numeric	Generic Edit	15	0	Allow NULL?

TOP 812 | 13R | F48311 INDEXES

Number

Description

UniqueTaskID (Primary/Unique)

Element	Alias	Description	Sequence
1	TSKID	Task Unique Key ID	Ascending

Resource Type Number +

Element	Alias	Description	Sequence
1	RRTY	Resource Type	Ascending
2	RSCN	Resource Number	Ascending
3	DOCO	Document (Order No Invoice etc.)	Ascending
4	OPSQ	Sequence Number - Operations	Ascending
5	OPSC	Type Operation Code	Ascending
6	MCU	Business Unit	Ascending

Document Sequence +

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	OPSQ	Sequence Number - Operations	Ascending
3	OPSC	Type Operation Code	Ascending
4	MCU	Business Unit	Ascending

Resource Type Number A

Element	Alias	Description	Sequence
1	RRTY	Resource Type	Ascending
2	RSCN	Resource Number	Ascending
3	IAVL	Availability Inclusion Flag	Ascending
4	SESD	Date - Scheduled Start (Julian)	Ascending
5	SCHSTTIME	Scheduled Start ANSI C UTC Time	Ascending
6	LPMD	Load Profile Method	Ascending
7	SEED	Date - Scheduled End (Julian)	Ascending

Project ID Document +

Element	Alias	Description	Sequence
1	PRJM	Project Number	Ascending
2	DOCO	Document (Order No Invoice etc.)	Ascending
3	OPSQ	Sequence Number - Operations	Ascending
4	OPSC	Type Operation Code	Ascending
5	MCU	Business Unit	Ascending

Type Number SEED +

Element	Alias	Description	Sequence
1	RRTY	Resource Type	Ascending
2	RSCN	Resource Number	Ascending
3	SEED	Date - Scheduled End (Julian)	Ascending
4	SESD	Date - Scheduled Start (Julian)	Ascending

RRTY DOCO AHRS +

Element	Alias	Description	Sequence
1	RRTY	Resource Type	Ascending
2	DOCO	Document (Order No Invoice etc.)	Ascending
3	OPSQ	Sequence Number - Operations	Ascending
4	OPSC	Type Operation Code	Ascending
5	MCU	Business Unit	Ascending
6	AHRS	Assigned Hours	Descending
7	TSKID	Task Unique Key ID	Ascending

ANSA SESD WSCHP

Element	Alias	Description	Sequence
1	ANSA	Address Number - Manager	Ascending
2	SESD	Date - Scheduled Start (Julian)	Ascending
3	WSCHP	Maintenance Scheduling Status	Ascending

JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

JDE TABLESv3

920: Top 10 requests

910: Top 10 requests

812: Top 10 requests

66 COLUMNS | 8 INDEXES | 812 | 13R | F48311 TABLE

TOP 812 | 13R | F48311 COLUMNS

TOP 812 | 13R | F48311 INDEXES

JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

JDE TABLESv3

920: Top 10 requests

910: Top 10 requests

812: Top 10 requests

66 COLUMNS | 8 INDEXES | 812 | 13R | F48311 TABLE

TOP812 | 13R | F48311 COLUMNS

TOP812 | 13R | F48311 INDEXES

TOP 812 | 13R | F48311 COLUMNS

TOP 812 | 13R | F48311 INDEXES