Z_COMMIT_EXPORT06 
Default Table Name  Z_COMMIT_EXPORT06 
Definition 
Name: COMMIT EXPORT 06  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_EXPORT06 Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
BATCH_ID    VARCHAR(10)  NO 
Name: Batch id for the export batch  Description: Batch id for the export batch.
 
EXP_ID    VARCHAR(10)  NO 
Name: Expense id  Description: Expense id.
 
S_EXP_STATUS_CD    VARCHAR(1)  NO 
Name: Expense Status code  Description: Expense Status code.
 
EMPL_ID    VARCHAR(20)  NO 
Name: Employee id  Description: Employee id.
 
EMPL_NAME    VARCHAR(61)  NO 
Name: Employee Name  Description: Employee Name.
 
VEND_ID    VARCHAR(20)  YES 
Name: Vendor id  Description: Vendor id.
 
EXPENSE_ID    NUMERIC(10, 0)  YES 
Name: Expense id  Description: Expense id.
 
UDT02_ID    VARCHAR(50)  YES 
Name: Project id  Description: Project id.
 
UDT01_ID    VARCHAR(50)  YES 
Name: Account id  Description: Account id.
 
UDT09_ID    VARCHAR(20)  YES 
Name: Organization id  Description: Organization id.
 
UDT04_ID    VARCHAR(20)  YES 
Name: Udt04  Description: Udt04.
 
UDT05_ID    VARCHAR(20)  YES 
Name: Udt05  Description: Udt05.
 
BASE_COMMIT_AMT    NUMERIC(15, 5)  NO 
Name: Base commit amount  Description: Base commit amount.
 
PAY_COMMIT_AMT    NUMERIC(15, 5)  NO 
Name: Pay commit amount  Description: Pay commit amount.
 
PAY_CURRENCY_CD    VARCHAR(3)  NO 
Name: Pay currency code  Description: Pay currency code.
 
BASE_CURRENCY_CD    VARCHAR(3)  NO 
Name: Base currency code  Description: Base currency code.
 
COMMIT_TYPE    VARCHAR(2)  NO 
Name: Commitment type  Description: Commitment type.
 
EXP_TYPE_CD    VARCHAR(10)  NO 
Name: Expense type code  Description: Expense type code.
 
EXP_RPT_TYPE_CD    VARCHAR(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    VARCHAR(35)  YES 
Name:  City name Description: City name.
 
COUNTY_NAME    VARCHAR(35)  YES 
Name: County name  Description: County name.
 
STATE_NAME    VARCHAR(35)  YES 
Name: State name  Description: State name.
 
COUNTRY_NAME    VARCHAR(45)  YES 
Name: Country name  Description: Country name.
 
PAYMENT_TYPE    VARCHAR(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    VARCHAR(10)  NO 
Name: Costpoint company code  Description: Costpoint company code.
 

Z_COMMIT_EXPORT06 Keys 
Key Name  Key Type  Keys 
SI_0149  Inversion Entry  BATCH_ID, EXP_ID, EXPENSE_ID 

Z_COMMIT_EXPORT06 Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype