SALES ORDER DETAIL Table
Sales Order information -- currently contains Tech Review data only
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AMOUNT |
The total actual dollar amount charged for the fiscal period or periods selected. In GRADUATE AWARDS, this field contains the graduate award (RA, TA, etc.) amount. |
NUMBER |
13.2 |
COST_COLLECTOR_KEY |
Key used to join the Cost Collector to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
12 |
CUSTOMER_SHIP_TO_CITY |
XXX |
VARCHAR2 |
35 |
CUSTOMER_SHIP_TO_COUNTRY |
XXX |
VARCHAR2 |
15 |
CUSTOMER_SHIP_TO_KEY |
XXX |
VARCHAR2 |
11 |
CUSTOMER_SHIP_TO_NAME |
XXX |
VARCHAR2 |
35 |
CUSTOMER_SHIP_TO_NUMBER |
XXX |
VARCHAR2 |
10 |
CUSTOMER_SHIP_TO_PHONE |
XXX |
VARCHAR2 |
16 |
CUSTOMER_SHIP_TO_STATE |
XXX |
VARCHAR2 |
3 |
CUSTOMER_SHIP_TO_STREET |
XXX |
VARCHAR2 |
35 |
CUSTOMER_SHIP_TO_ZIP |
XXX |
VARCHAR2 |
10 |
CUSTOMER_SOLD_TO_CITY |
XXX |
VARCHAR2 |
35 |
CUSTOMER_SOLD_TO_COUNTRY |
XXX |
VARCHAR2 |
15 |
CUSTOMER_SOLD_TO_KEY |
XXX |
VARCHAR2 |
11 |
CUSTOMER_SOLD_TO_NAME |
XXX |
VARCHAR2 |
35 |
CUSTOMER_SOLD_TO_NUMBER |
XXX |
VARCHAR2 |
10 |
CUSTOMER_SOLD_TO_PHONE |
XXX |
VARCHAR2 |
16 |
CUSTOMER_SOLD_TO_STATE |
XXX |
VARCHAR2 |
3 |
CUSTOMER_SOLD_TO_STREET |
XXX |
VARCHAR2 |
35 |
CUSTOMER_SOLD_TO_ZIP |
XXX |
VARCHAR2 |
10 |
DOCUMENT_TYPE |
XXX |
VARCHAR2 |
2 |
MATERIAL_KEY |
XXX |
VARCHAR2 |
18 |
PRICING_ELEMENT_KEY |
Key field used to join to the PRICING_ELEMENT table. This field should only be used for joining data, NOT for reporting |
VARCHAR2 |
10 |
REQUESTED_DELIVERY_DATE |
XXX |
DATE |
8 |
SALES_ORDER_CREATE_DATE |
XXX |
DATE |
8 |
SALES_ORDER_CREATE_USER |
XXX |
VARCHAR2 |
12 |
SALES_ORDER_LINE_ITEM |
XXX |
NUMBER |
22 |
SALES_ORDER_NUMBER |
XXX |
VARCHAR2 |
10 |
SALES_ORDER_ORGANIZATION |
XXX |
VARCHAR2 |
10 |
SALES_ORDER_PARTNER_KEY |
Key field used to join to the SALES_ORDER_PARTNER table. This field should only be used for joining data, NOT for reporting |
VARCHAR2 |
20 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |