ERPRef.com
is JDE Date
58 COLUMNS | 2 INDICIES 812 | 40R | F47UI002 ASN Extract Packaging Work File
| Schema | Name | Prefix | Columns | Indicies | Description | Type | Report | Category |
|---|---|---|---|---|---|---|---|---|
| 812 | F47UI002 | SP | 58 | 2 | ASN Extract Packaging Work File | Files | 40R: Demand Scheduling |
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 SQL
Insert SQL
Update SQL
Create SQL
58 COLUMNS | TOP 812 | 40R | F47UI002 ASN Extract Packaging Work File
| Col# | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
2 INDICIES | TOP 812 | 40R | F47UI002 ASN Extract Packaging Work File
1: ComputerId Job Number + (Primary/Unique)
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 1 | CTID | Computer ID | Ascending |
| 2 | JOBS | Job Number | Ascending |
| 3 | HLCF | Hierarchical Configuration | Ascending |
| 4 | VC30A | Video Constant A - length 30 | Ascending |
| 5 | VC30A1 | Video Constant A1 - length 30 | Ascending |
| 6 | VC30A2 | Video Constant A2 - length 30 | Ascending |
| 7 | VC30A3 | Video Constant A3 - length 30 | Ascending |
| 8 | VC30A4 | Video Constant A4 - length 30 | Ascending |
| 9 | VC30A5 | Video Constant A5 - length 30 | Ascending |
| 10 | VC30A6 | Video Constant A6 - length 30 | Ascending |
| 11 | VC30A7 | Video Constant A7 - length 30 | Ascending |
| 12 | VC30A8 | Video Constant A8 - length 30 | Ascending |
| 13 | SEQN | Sequence Number | Ascending |
2: Cust Carton Id Carton ItemNo +
| Element | Alias | Description | Sequence |
|---|---|---|---|
| 1 | CHGREF | Charge Reference Number | Ascending |
| 2 | EQTY | Container Code | Ascending |
| 3 | CRID | Carton ID | Ascending |