SALES CONTRACT ALL Table
View exposing the full sales contract detail set including contract and line-item identifiers, dates, amounts, cost collector and project references, customer sold-to, payer, bill-to, and ship-to details, purchase-order attributes, billing-plan rules, and cumulative billed amount.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADVANCE_BILLING_FLAG |
Indicator identifying whether advance billing (Y/N). |
VARCHAR2 |
1 |
BILLED_THRU_DATE |
Date associated with billed thru. |
DATE |
|
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_END_DATE |
Date associated with billing plan end. |
DATE |
|
BILLING_PLAN_KEY |
Surrogate key identifying the billing plan. |
VARCHAR2 |
10 |
BILLING_PLAN_START_DATE |
Date associated with billing plan start. |
DATE |
|
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 |
CONTRACT_AMOUNT |
Contract amount associated with the record. |
NUMBER |
15,2 |
CONTRACT_CANCELATION_REASON |
Contract cancelation reason associated with the record. |
VARCHAR2 |
40 |
CONTRACT_CANCEL_REASON_CODE |
Code identifying contract cancel reason. |
VARCHAR2 |
2 |
CONTRACT_CREATE_DATE |
Date associated with contract create. |
DATE |
|
CONTRACT_CREATE_USER |
Contract create user associated with the record. |
VARCHAR2 |
12 |
CONTRACT_END_DATE |
Date associated with contract end. |
DATE |
|
CONTRACT_START_DATE |
Date associated with contract start. |
DATE |
|
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
12 |
CUMULATIVE_AMOUNT_BILLED |
Cumulative amount billed associated with the record. |
NUMBER |
18,2 |
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_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_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 |
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 |
LAST_BILLING_DATE |
Date associated with last billing. |
DATE |
|
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 |
MIT_AWARD_NUMBER |
Mit award number associated with the record. |
VARCHAR2 |
20 |
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 |
REFERENCE_NUMBER |
Reference number associated with the record. |
VARCHAR2 |
16 |
SALES_CONTRACT_LINE_ITEM |
Sales contract line item associated with the record. |
NUMBER |
6 |
SALES_CONTRACT_NUMBER |
Sales contract number associated with the record. |
VARCHAR2 |
10 |
SALES_CONTRACT_TITLE |
Sales contract title associated with the record. |
VARCHAR2 |
40 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |