Z_COMMIT_EXPORT10 
Default Table Name  Z_COMMIT_EXPORT10 
Definition 
Name: COMMIT EXPORT 10  Description: This table is a temporary table used for the export of commitments. Since 10 exports can be run concurrently, this table is used when the first concurrent export is executed.
 

Z_COMMIT_EXPORT10 Columns 
ColumnName  Domain  Datatype  NULL  Definition 
BATCH_ID    VARCHAR2(10)  NO 
Name: Batch id for the export batch  Description: Batch id for the export batch.
 
EXP_ID    VARCHAR2(10)  NO 
Name: Expense id  Description: Expense id.
 
S_EXP_STATUS_CD    VARCHAR2(1)  NO 
Name: Expense Status code  Description: Expense Status code.
 
EMPL_ID    VARCHAR2(20)  NO 
Name: Employee id  Description: Employee id.
 
EMPL_NAME    VARCHAR2(61)  NO 
Name: Employee Name  Description: Employee Name.
 
VEND_ID    VARCHAR2(20)  YES 
Name: Vendor id  Description: Vendor id.
 
EXPENSE_ID    NUMBER(10, 0)  YES 
Name: Expense id  Description: Expense id.
 
UDT02_ID    VARCHAR2(50)  YES 
Name: Project id  Description: Project id.
 
UDT01_ID    VARCHAR2(50)  YES 
Name: Account id  Description: Account id.
 
UDT09_ID    VARCHAR2(20)  YES 
Name: Organization id  Description: Organization id.
 
UDT04_ID    VARCHAR2(20)  YES 
Name: Udt04  Description: Udt04.
 
UDT05_ID    VARCHAR2(20)  YES 
Name: Udt05  Description: Udt05.
 
BASE_COMMIT_AMT    NUMBER(15, 5)  NO 
Name: Base commit amount  Description: Base commit amount.
 
PAY_COMMIT_AMT    NUMBER(15, 5)  NO 
Name: Pay commit amount  Description: Pay commit amount.
 
PAY_CURRENCY_CD    VARCHAR2(3)  NO 
Name: Pay currency code  Description: Pay currency code.
 
BASE_CURRENCY_CD    VARCHAR2(3)  NO 
Name: Base currency code  Description: Base currency code.
 
COMMIT_TYPE    VARCHAR2(2)  NO 
Name: Commitment type  Description: Commitment type.
 
EXP_TYPE_CD    VARCHAR2(10)  NO 
Name: Expense type code  Description: Expense type code.
 
EXP_RPT_TYPE_CD    VARCHAR2(10)  NO 
Name: Expense Report Type Code  Description: Expense Report Type Code.
 
START_DT    DATE  NO 
Name: Start date  Description: Start date.
 
END_DT    DATE  NO 
Name: End date  Description: End date.
 
CITY_NAME    VARCHAR2(35)  YES 
Name:  City name Description: City name.
 
COUNTY_NAME    VARCHAR2(35)  YES 
Name: County name  Description: County name.
 
STATE_NAME    VARCHAR2(35)  YES 
Name: State name  Description: State name.
 
COUNTRY_NAME    VARCHAR2(45)  YES 
Name: Country name  Description: Country name.
 
PAYMENT_TYPE    VARCHAR2(10)  YES 
Name: Payment Type  Description: Payment Type.
 
COMMIT_DT    DATE  NO 
Name: Commitment date  Description: Commitment date.
 
COMMIT_CALC_DTT    DATE  NO 
Name: Commitment Calculation date  Description: Commitment Calculation date.
 
CP_COMPANY_CD    VARCHAR2(10)  NO 
Name: Costpoint company code  Description: Costpoint company code.
 

Z_COMMIT_EXPORT10 Primary and Unique Keys 
Key Name  Key Type  Keys 

Z_COMMIT_EXPORT10 Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable