| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | SCKCOO | Order Company (Order Number) | String | Generic Edit | 5 | 0 | Allow NULL? |
| 2 | SCDOCO | Document (Order No Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 3 | SCSFXO | Order Suffix | String | Generic Edit | 3 | 0 | Allow NULL? |
| 4 | SCDOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 5 | SCDLIJ | Date - Last Invoice (Julian) | Date | Generic Edit | 6 | 0 | |
| 6 | SCAN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 7 | SCSLSP | Salesperson | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 8 | SCCCTY | Commission Code Type | Character | UDC (H42 CC) | 1 | 0 | Allow NULL? |
| 9 | SCRAN8 | Related - Address Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 10 | SCCTYR | Commission Code Type - Related | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 11 | SCDCTO | Order Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 12 | SCLNID | Line Number | Numeric | Generic Edit | 6 | 3 | Allow NULL? |
| 13 | SCAC01 | Category Code - Address Book 01 | String | UDC (01 01) | 3 | 0 | Allow NULL? |
| 14 | SCAC02 | Category Code - Address Book 02 | String | UDC (01 02) | 3 | 0 | Allow NULL? |
| 15 | SCAC03 | Category Code - Address Book 03 | String | UDC (01 03) | 3 | 0 | Allow NULL? |
| 16 | SCAC04 | Category Code - Address Book 04 | String | UDC (01 04) | 3 | 0 | Allow NULL? |
| 17 | SCAC05 | Category Code - Address Book 05 | String | UDC (01 05) | 3 | 0 | Allow NULL? |
| 18 | SCSRP1 | Sales Rpt 01 - Product Family | String | UDC (41 S1) | 3 | 0 | Allow NULL? |
| 19 | SCSRP2 | Sales Rpt 02 - Family Section | String | UDC (41 S2) | 3 | 0 | Allow NULL? |
| 20 | SCSRP3 | Sales Category Code 3 | String | UDC (41 S3) | 3 | 0 | Allow NULL? |
| 21 | SCSRP4 | Sales Category Code 4 | String | UDC (41 S4) | 3 | 0 | Allow NULL? |
| 22 | SCSRP5 | Sales Category Code 5 | String | UDC (41 S5) | 3 | 0 | Allow NULL? |
| 23 | SCSPLT | Code - Division Split | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 24 | SCFRTH | Freight Handling Code | String | UDC (42 FR) | 3 | 0 | Allow NULL? |
| 25 | SCLFAC | Load Factor | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 26 | SCAFXC | Amount - Fixed Cost | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 27 | SCTOTO | Amount - Sales Total Order | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 28 | SCORCS | Amount - Sales Order Total Cost | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 29 | SCREBT | Amount - Rebate Cost Total Order | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 30 | SCMRGN | Amount - Order Gross Margin | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 31 | SCELIG | Amount - Order Eligible Margin | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 32 | SCTOTL | Amount - Sales Total Line | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 33 | SCLRCS | Amount - Sales Line Total Cost | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 34 | SCREBL | Amount - Rebate Cost Total Line | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 35 | SCMRGL | Amount - Line Gross Margin | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 36 | SCELIL | Amount - Line Eligible Margin | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 37 | SCMGM | Amount - Minimum Gross Margin Dollars | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 38 | SCCPCT | Percent - Commission | Numeric | Generic Edit | 7 | 3 | Allow NULL? |
| 39 | SCCOMA | Amount - Commission | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 40 | SCCPCR | Percent - Related Commission | Numeric | Generic Edit | 6 | 3 | Allow NULL? |
| 41 | SCCOMR | Amount - Related Commission | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 42 | SCMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 43 | SCITM | Item Number - Short | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 44 | SCRPMB | Replaced By | String | Generic Edit | 10 | 0 | Allow NULL? |
| 45 | SCUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 46 | SCCMDJ | Date - Commission Paid | Date | Generic Edit | 6 | 0 | |
| 47 | SCPDCD | Code - Paid | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 48 | SCCLOJ | Date- Closed | Date | Generic Edit | 6 | 0 | |
| 49 | SCTDAY | Time of Day | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 50 | SCFCA | Flat Commission Amount | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 51 | SCAPUN | Amount - Per Unit | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 52 | SCCMLN | Commission LineNumber | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
