X_Z_AOMVSPJ1_WRK1 |
Default Table Name | X_Z_AOMVSPJ1_WRK1 |
Definition |
X_Z_AOMVSPJ1_WRK1 Columns |
ColumnName | Domain | Datatype | NULL | Definition |
TOPLEVELPROJID | VARCHAR2(70) | YES | ||
PROJ_ID | VARCHAR2(70) | YES | ||
PRWBS1 | VARCHAR2(30) | NO | ||
PRWBS2 | VARCHAR2(7) | NO | ||
PRWBS3 | VARCHAR2(7) | NO | ||
NAME | VARCHAR2(40) | YES | ||
CHARGETYPE | VARCHAR2(1) | YES | ||
SUBLEVEL | VARCHAR2(1) | NO | ||
PRINCIPAL | VARCHAR2(20) | YES | ||
PROJMGR | VARCHAR2(20) | YES | ||
SUPERVISOR | VARCHAR2(20) | YES | ||
CLIENTID | VARCHAR2(32) | YES | ||
CLADDRESS | VARCHAR2(20) | YES | ||
FEE | NUMBER(19, 4) | NO | ||
REIMBALLOW | NUMBER(19, 4) | NO | ||
CONSULTFEE | NUMBER(19, 4) | NO | ||
BUDOHRATE | NUMBER(19, 4) | NO | ||
STATUS | VARCHAR2(1) | YES | ||
REVTYPE | VARCHAR2(10) | YES | ||
MULTAMT | NUMBER(19, 4) | NO | ||
ORG | VARCHAR2(14) | YES | ||
UNITTABLE | VARCHAR2(20) | YES | ||
STARTDATE | DATE | YES | ||
ENDDATE | DATE | YES | ||
PCTCOMP | NUMBER(19, 4) | NO | ||
LABPCTCOMP | NUMBER(19, 4) | NO | ||
EXPPCTCOMP | NUMBER(19, 4) | NO | ||
BILLBYDEFAULT | VARCHAR2(1) | NO | ||
BILLABLEWARNING | VARCHAR2(1) | NO | ||
MEMO | CLOB | YES | ||
BUDGETEDFLAG | VARCHAR2(1) | NO | ||
BUDGETEDLEVELS | VARCHAR2(5) | YES | ||
BILLWBS1 | VARCHAR2(30) | YES | ||
BILLWBS2 | VARCHAR2(7) | YES | ||
BILLWBS3 | VARCHAR2(7) | YES | ||
XCHARGE | VARCHAR2(1) | NO | ||
XCHARGEMETHOD | NUMBER(5, 0) | NO | ||
XCHARGEMULT | NUMBER(19, 4) | NO | ||
DESCRIPTION | VARCHAR2(254) | YES | ||
CLOSED | NUMBER(10, 0) | NO | ||
READONLY | NUMBER(10, 0) | NO | ||
DEFAULTEFFORTDRIVEN | NUMBER(10, 0) | NO | ||
DEFAULTTASKTYPE | NUMBER(10, 0) | NO | ||
VERSIONID | NUMBER(10, 0) | NO | ||
CONTACTID | VARCHAR2(32) | YES | ||
CLBILLINGADDR | VARCHAR2(20) | YES | ||
LONGNAME | VARCHAR2(254) | YES | ||
ADDRESS1 | VARCHAR2(50) | YES | ||
ADDRESS2 | VARCHAR2(50) | YES | ||
ADDRESS3 | VARCHAR2(50) | YES | ||
CITY | VARCHAR2(30) | YES | ||
STATE | VARCHAR2(10) | YES | ||
ZIP | VARCHAR2(10) | YES | ||
COUNTY | VARCHAR2(50) | YES | ||
COUNTRY | VARCHAR2(40) | YES | ||
FEDERALIND | VARCHAR2(1) | NO | ||
PROJECTTYPE | VARCHAR2(10) | YES | ||
RESPONSIBILITY | VARCHAR2(10) | YES | ||
REFERABLE | VARCHAR2(1) | NO | ||
ESTCOMPLETIONDATE | DATE | YES | ||
ACTCOMPLETIONDATE | DATE | YES | ||
CONTRACTDATE | DATE | YES | ||
BIDDATE | DATE | YES | ||
COMPLDATECOMMENT | VARCHAR2(20) | YES | ||
FIRMCOST | NUMBER(19, 4) | NO | ||
FIRMCOSTCOMMENT | VARCHAR2(20) | YES | ||
TOTALPROJECTCOST | NUMBER(19, 4) | NO | ||
TOTALCOSTCOMMENT | VARCHAR2(20) | YES | ||
OPPORTUNITYID | VARCHAR2(32) | YES | ||
CLIENTCONFIDENTIAL | VARCHAR2(1) | YES | ||
CLIENTALIAS | VARCHAR2(100) | YES | ||
AVAILABLEFORCRM | VARCHAR2(1) | NO | ||
READYFORAPPROVAL | VARCHAR2(1) | NO | ||
READYFORPROCESSING | VARCHAR2(1) | NO | ||
BILLINGCLIENTID | VARCHAR2(32) | YES | ||
BILLINGCONTACTID | VARCHAR2(32) | YES | ||
PHONE | VARCHAR2(24) | YES | ||
FAX | VARCHAR2(24) | YES | ||
VARCHAR2(50) | YES | |||
PROPOSALWBS1 | VARCHAR2(30) | YES | ||
CREATEUSER | VARCHAR2(20) | YES | ||
CREATEDATE | DATE | YES | ||
MODUSER | VARCHAR2(20) | YES | ||
MODDATE | DATE | YES | ||
COSTRATEMETH | NUMBER(5, 0) | NO | ||
COSTRATETABLENO | NUMBER(5, 0) | NO | ||
PAYRATEMETH | NUMBER(5, 0) | NO | ||
PAYRATETABLENO | NUMBER(5, 0) | NO | ||
LOCALE | VARCHAR2(2) | YES | ||
LINEITEMAPPROVAL | VARCHAR2(1) | NO | ||
LINEITEMAPPROVALEK | VARCHAR2(1) | NO | ||
BUDGETSOURCE | VARCHAR2(1) | YES | ||
BUDGETLEVEL | VARCHAR2(1) | YES | ||
WBS1 | VARCHAR2(30) | NO | ||
WBS2 | VARCHAR2(7) | NO | ||
WBS3 | VARCHAR2(7) | NO | ||
CUSTSENDTOCOSTPOINT | VARCHAR2(1) | YES | ||
CUSTSENTTOCOSTPOINT | VARCHAR2(1) | YES | ||
CUSTLASTEXPORTED | VARCHAR2(70) | YES | ||
CUSTCREATELEVELS | VARCHAR2(1) | YES | ||
CUSTDEFAULTPROJID | VARCHAR2(70) | YES | ||
INDEXCOUNT | NUMBER(10, 0) | YES | ||
NUMLEVELS | NUMBER(10, 0) | YES | ||
VALIDFLAG | VARCHAR2(1) | YES | ||
CUSTBASEENDDATE | DATE | YES | ||
CUSTCONTRACTSTARTDATE | DATE | YES | ||
CUSTPRIMECONTRACTNUMBER | VARCHAR2(70) | YES |
X_Z_AOMVSPJ1_WRK1 Primary and Unique Keys |
Key Name | Key Type | Keys |
X_Z_AOMVSPJ1_WRK1 Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |