SALES ORDER DETAIL PROJECT Table
View exposing project-related sales order detail including sales-order and line-item identifiers, condition attributes, project and cost collector references, billing and customer details, pricing elements, amounts, and requested delivery date.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACCRUAL_PERIOD |
Accrual period associated with the record. |
NUMBER |
2 |
ADVANCE_BILLING_FLAG |
Indicator identifying whether advance billing (Y/N). |
VARCHAR2 |
1 |
AMOUNT |
Amount associated with the record. |
NUMBER |
13,2 |
BILLING_BLOCK |
Billing block associated with the record. |
VARCHAR2 |
2 |
BILLING_DATE |
Date associated with billing. |
VARCHAR2 |
8 |
BILLING_PERIOD_RULE |
Billing period rule associated with the record. |
VARCHAR2 |
60 |
BILLING_PERIOD_RULE_CODE |
Code identifying billing period rule. |
VARCHAR2 |
2 |
BILLING_PLAN_TYPE |
Billing plan type associated with the record. |
VARCHAR2 |
30 |
BILLING_PLAN_TYPE_CODE |
Code identifying billing plan type. |
VARCHAR2 |
2 |
BILLING_SPECIAL_HANDLING |
Billing special handling associated with the record. |
VARCHAR2 |
30 |
BILL_SPECIAL_HANDLING_CODE |
Code identifying bill special handling. |
VARCHAR2 |
4 |
CONDITION_CODE |
Code identifying condition. |
VARCHAR2 |
4 |
CONDITION_COUNTER |
Condition counter associated with the record. |
VARCHAR2 |
3 |
CONDITION_STEP |
Condition step associated with the record. |
VARCHAR2 |
3 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
12 |
CURRENCY_KEY |
Surrogate key identifying the currency. |
VARCHAR2 |
5 |
CUSTOMER_BILL_TO_CITY |
Customer bill to city associated with the record. |
VARCHAR2 |
35 |
CUSTOMER_BILL_TO_COUNTRY |
Customer bill to country associated with the record. |
VARCHAR2 |
15 |
CUSTOMER_BILL_TO_KEY |
Surrogate key identifying the customer bill to. |
VARCHAR2 |
11 |
CUSTOMER_BILL_TO_NAME |
Customer bill to name associated with the person or organization. |
VARCHAR2 |
50 |
CUSTOMER_BILL_TO_NUMBER |
Customer bill to number associated with the record. |
VARCHAR2 |
10 |
CUSTOMER_BILL_TO_PHONE |
Customer bill to phone associated with the record. |
VARCHAR2 |
16 |
CUSTOMER_BILL_TO_STATE |
Customer bill to state associated with the record. |
VARCHAR2 |
3 |
CUSTOMER_BILL_TO_STREET |
Customer bill to street associated with the record. |
VARCHAR2 |
35 |
CUSTOMER_BILL_TO_ZIP |
Customer bill to zip associated with the record. |
VARCHAR2 |
10 |
CUSTOMER_PAYER_CITY |
Customer payer city associated with the record. |
VARCHAR2 |
35 |
CUSTOMER_PAYER_COUNTRY |
Customer payer country associated with the record. |
VARCHAR2 |
15 |
CUSTOMER_PAYER_KEY |
Surrogate key identifying the customer payer. |
VARCHAR2 |
11 |
CUSTOMER_PAYER_NAME |
Customer payer name associated with the person or organization. |
VARCHAR2 |
50 |
CUSTOMER_PAYER_NUMBER |
Customer payer number associated with the record. |
VARCHAR2 |
10 |
CUSTOMER_PAYER_PHONE |
Customer payer phone associated with the record. |
VARCHAR2 |
16 |
CUSTOMER_PAYER_STATE |
Customer payer state associated with the record. |
VARCHAR2 |
3 |
CUSTOMER_PAYER_STREET |
Customer payer street associated with the record. |
VARCHAR2 |
35 |
CUSTOMER_PAYER_ZIP |
Customer payer zip associated with the record. |
VARCHAR2 |
10 |
CUSTOMER_SHIP_TO_CITY |
Customer ship to city associated with the record. |
VARCHAR2 |
35 |
CUSTOMER_SHIP_TO_COUNTRY |
Customer ship to country associated with the record. |
VARCHAR2 |
15 |
CUSTOMER_SHIP_TO_KEY |
Surrogate key identifying the customer ship to. |
VARCHAR2 |
11 |
CUSTOMER_SHIP_TO_NAME |
Customer ship to name associated with the person or organization. |
VARCHAR2 |
50 |
CUSTOMER_SHIP_TO_NUMBER |
Customer ship to number associated with the record. |
VARCHAR2 |
10 |
CUSTOMER_SHIP_TO_PHONE |
Customer ship to phone associated with the record. |
VARCHAR2 |
16 |
CUSTOMER_SHIP_TO_STATE |
Customer ship to state associated with the record. |
VARCHAR2 |
3 |
CUSTOMER_SHIP_TO_STREET |
Customer ship to street associated with the record. |
VARCHAR2 |
35 |
CUSTOMER_SHIP_TO_ZIP |
Customer ship to zip associated with the record. |
VARCHAR2 |
10 |
CUSTOMER_SOLD_TO_CITY |
Customer sold to city associated with the record. |
VARCHAR2 |
35 |
CUSTOMER_SOLD_TO_COUNTRY |
Customer sold to country associated with the record. |
VARCHAR2 |
15 |
CUSTOMER_SOLD_TO_KEY |
Surrogate key identifying the customer sold to. |
VARCHAR2 |
11 |
CUSTOMER_SOLD_TO_NAME |
Customer sold to name associated with the person or organization. |
VARCHAR2 |
50 |
CUSTOMER_SOLD_TO_NUMBER |
Customer sold to number associated with the record. |
VARCHAR2 |
10 |
CUSTOMER_SOLD_TO_PHONE |
Customer sold to phone associated with the record. |
VARCHAR2 |
16 |
CUSTOMER_SOLD_TO_STATE |
Customer sold to state associated with the record. |
VARCHAR2 |
3 |
CUSTOMER_SOLD_TO_STREET |
Customer sold to street associated with the record. |
VARCHAR2 |
35 |
CUSTOMER_SOLD_TO_ZIP |
Customer sold to zip associated with the record. |
VARCHAR2 |
10 |
DELIVERY_BLOCK |
Delivery block associated with the record. |
VARCHAR2 |
2 |
DEVIATING_BILL_DATE_RULE |
Deviating bill date rule associated with the record. |
VARCHAR2 |
60 |
DEVIATING_BILL_DATE_RULE_CODE |
Code identifying deviating bill date rule. |
VARCHAR2 |
2 |
DOCUMENT_CATEGORY |
Document category associated with the record. |
VARCHAR2 |
1 |
DOCUMENT_CATEGORY_DESC |
Description of document category. |
VARCHAR2 |
10 |
DOCUMENT_TYPE |
Document type associated with the record. |
VARCHAR2 |
4 |
INVOICE_PRINTING |
Invoice printing associated with the record. |
VARCHAR2 |
30 |
INVOICE_PRINTING_CODE |
Code identifying invoice printing. |
VARCHAR2 |
4 |
ITEM_BILLING_BLOCK_STATUS |
Item billing block status associated with the record. |
VARCHAR2 |
1 |
ITEM_DELIVERY_BLOCK_STATUS |
Item delivery block status associated with the record. |
VARCHAR2 |
1 |
ITEM_REJECTION_STATUS |
Item rejection status associated with the record. |
VARCHAR2 |
1 |
ITEM_REJECTION_STAT_DESC |
Description of item rejection stat. |
VARCHAR2 |
45 |
LINE_ITEM_AMOUNT |
Line item amount associated with the record. |
NUMBER |
15,2 |
LINE_ITEM_CATEGORY |
Line item category associated with the record. |
VARCHAR2 |
4 |
LINE_ITEM_ENTRY_DATE |
Date associated with line item entry. |
DATE |
|
LINE_ITEM_ENTRY_USER |
Line item entry user associated with the record. |
VARCHAR2 |
12 |
LINE_ITEM_REJECTION_REASON |
Line item rejection reason associated with the record. |
VARCHAR2 |
40 |
LINE_ITEM_REJECT_REASON_CODE |
Code identifying line item reject reason. |
VARCHAR2 |
2 |
LINE_ITEM_TEXT |
Line item text associated with the record. |
VARCHAR2 |
40 |
MATERIAL_ENTERED |
Material entered associated with the record. |
VARCHAR2 |
18 |
MATERIAL_KEY |
Surrogate key identifying the material. |
VARCHAR2 |
18 |
PRICING_ELEMENT_KEY |
Surrogate key identifying the pricing element. |
VARCHAR2 |
10 |
PROJECT_WBS_ID |
Business identifier for the project wbs. |
VARCHAR2 |
7 |
PURCHASE_ORDER_DATE |
Date associated with purchase order. |
DATE |
|
PURCHASE_ORDER_NUMBER |
Purchase order number associated with the record. |
VARCHAR2 |
35 |
REQUESTED_DELIVERY_DATE |
Date associated with requested delivery. |
DATE |
|
SALES_ORDER_AMOUNT |
Sales order amount associated with the record. |
NUMBER |
15,2 |
SALES_ORDER_CREATE_DATE |
Date associated with sales order create. |
DATE |
|
SALES_ORDER_CREATE_USER |
Sales order create user associated with the record. |
VARCHAR2 |
12 |
SALES_ORDER_END_DATE |
Date associated with sales order end. |
DATE |
|
SALES_ORDER_LINE_ITEM |
Sales order line item associated with the record. |
NUMBER |
6 |
SALES_ORDER_NUMBER |
Sales order number associated with the record. |
VARCHAR2 |
10 |
SALES_ORDER_ORGANIZATION |
Sales order organization associated with the record. |
VARCHAR2 |
10 |
SALES_ORDER_PARTNER_KEY |
Surrogate key identifying the sales order partner. |
VARCHAR2 |
20 |
SALES_ORDER_START_DATE |
Date associated with sales order start. |
DATE |
|
WAREHOUSE_CURRENT_TIMESTAMP |
Warehouse current timestamp associated with the warehouse record. |
DATE |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |