X_Z_AOPUTLTE_ED4 |
Default Table Name | X_Z_AOPUTLTE_ED4 |
Definition |
X_Z_AOPUTLTE_ED4 Columns |
ColumnName | Domain | Datatype | NULL | Definition |
VENDOR_ID | VARCHAR2(12) | YES | ||
VENDOR_NAME | VARCHAR2(25) | YES | ||
VENDOR_NAME_EXT | VARCHAR2(6) | YES | ||
PAY_VENDOR_ID | VARCHAR2(12) | YES | ||
PO_ID | VARCHAR2(10) | YES | ||
PO_RELEASE_NO | NUMBER(5, 0) | YES | ||
TERMS | VARCHAR2(15) | YES | ||
APPROVED | VARCHAR2(1) | YES | ||
INVOICE_ID | VARCHAR2(15) | YES | ||
INVOICE_DATE | DATE | YES | ||
BATCH_ID | VARCHAR2(20) | YES | ||
ENTRY_USER_ID | VARCHAR2(20) | YES | ||
FISCAL_YEAR | VARCHAR2(6) | YES | ||
PERIOD_NO | NUMBER(5, 0) | YES | ||
SUBPERIOD_NO | NUMBER(5, 0) | YES | ||
INVOICE_AMOUNT | NUMBER(17, 2) | YES | ||
DISCOUNT_AMOUNT | NUMBER(17, 2) | YES | ||
DUE_AMOUNT | NUMBER(17, 2) | YES | ||
DUE_DATE | DATE | YES | ||
AP_ACCOUNT_ID | VARCHAR2(15) | YES | ||
AP_ORG_ID | VARCHAR2(20) | YES | ||
CASH_ACCOUNT_ID | VARCHAR2(15) | YES | ||
CASH_ORG_ID | VARCHAR2(20) | YES | ||
CASH_REFERENCE_1 | VARCHAR2(20) | YES | ||
CASH_REFERENCE_2 | VARCHAR2(20) | YES | ||
DISCOUNT_TAKEN_AMT | NUMBER(17, 2) | YES | ||
CHECK_AMT | NUMBER(17, 2) | YES | ||
CHECK_DATE | DATE | YES | ||
CHECK_NO | NUMBER(10, 0) | YES | ||
VOUCHER_NO | NUMBER(10, 0) | YES | ||
RECURRING | VARCHAR2(1) | YES | ||
VOUCHER_TYPE | VARCHAR2(3) | YES | ||
VOUCHER_LINE_NO | NUMBER(5, 0) | YES | ||
ACCOUNT | VARCHAR2(15) | YES | ||
ORGANIZATION | VARCHAR2(20) | YES | ||
PROJECT | VARCHAR2(30) | YES | ||
DESCRIPTION | VARCHAR2(30) | YES | ||
TOTAL_BEF_DISCOUNT | NUMBER(17, 2) | YES | ||
ACCOUNT_NAME | VARCHAR2(25) | YES | ||
ORG_NAME | VARCHAR2(25) | YES | ||
PROJECT_NAME | VARCHAR2(25) | YES | ||
REFERENCE_1 | VARCHAR2(20) | YES | ||
REFERENCE_2 | VARCHAR2(20) | YES | ||
COST_AMT_PCT_RATE | NUMBER(5, 4) | YES | ||
COST_AMOUNT | NUMBER(17, 2) | YES | ||
SALES_TAX_AMOUNT | NUMBER(17, 2) | YES | ||
LN_ACCT_DISC_AMT | NUMBER(17, 2) | YES | ||
NET_AMOUNT | NUMBER(17, 2) | YES | ||
USE_TAX_AMOUNT | NUMBER(17, 2) | YES | ||
NOTES | VARCHAR2(254) | YES | ||
LN_SALES_TAX_AMT | NUMBER(17, 2) | YES | ||
LN_USE_TAX_AMT | NUMBER(17, 2) | YES | ||
LN_DISC_AMT | NUMBER(17, 2) | YES | ||
UNIT_CST_AMT | NUMBER(17, 2) | YES | ||
EXT_CST_AMT | NUMBER(17, 2) | YES | ||
DISCR_TOT_AMT | NUMBER(17, 2) | YES | ||
LN_CHG_CST_AMT | NUMBER(17, 2) | YES | ||
LN_CHG_TAX_AMT | NUMBER(17, 2) | YES | ||
LN_CHG_USE_TAX_AMT | NUMBER(17, 2) | YES | ||
VCHR_LN_ACCT_KEY | NUMBER(10, 0) | YES | ||
HDR_NOTES | VARCHAR2(254) | YES | ||
HOLD_VCHR_FL | VARCHAR2(1) | YES | ||
PRINT_NOTE_FL | VARCHAR2(1) | YES | ||
RECUR_TMPLT_FL | VARCHAR2(1) | YES | ||
OVR_BUD_FL | VARCHAR2(1) | YES | ||
SHIP_AMT | NUMBER(17, 2) | YES | ||
S_INVC_TYPE | VARCHAR2(1) | YES | ||
PO_LN_NO | NUMBER(10, 0) | YES | ||
LN_ACCT_BEF_DISC | NUMBER(17, 2) | YES | ||
TRN_INVC_AMT | NUMBER(17, 2) | YES | ||
TRN_DISC_AMT | NUMBER(17, 2) | YES | ||
TRN_DUE_AMT | NUMBER(17, 2) | YES | ||
TRN_CST_AMT | NUMBER(17, 2) | YES | ||
TRN_SALES_TAX_AMT | NUMBER(17, 2) | YES | ||
TRN_USE_TAX_AMT | NUMBER(17, 2) | YES | ||
TRN_NET_AMT | NUMBER(17, 2) | YES | ||
TRN_RECOVERY_AMT | NUMBER(17, 2) | YES | ||
TRN_LN_TAX_AMT | NUMBER(17, 2) | YES | ||
TRN_LN_USE_TAX_AMT | NUMBER(17, 2) | YES | ||
TRN_LN_DISC_AMT | NUMBER(17, 2) | YES | ||
TRN_UNIT_CST_AMT | NUMBER(17, 2) | YES | ||
TRN_EXT_CST_AMT | NUMBER(17, 2) | YES | ||
TRN_TOT_BEF_DC_AMT | NUMBER(17, 2) | YES | ||
TRN_LN_CHG_CST_AMT | NUMBER(17, 2) | YES | ||
TRN_LN_CHG_TAX_AMT | NUMBER(17, 2) | YES | ||
TRN_LN_CHG_USE_AMT | NUMBER(17, 2) | YES | ||
TRN_SHIP_AMT | NUMBER(17, 2) | YES | ||
EXP_RPT_ID | VARCHAR2(12) | YES | ||
EXP_RPT_PAY_AMT | NUMBER(17, 2) | YES | ||
TRN_CRNCY_CD | VARCHAR2(3) | YES | ||
TRN_CRNCY_NAME | VARCHAR2(35) | YES | ||
TRN_CRNCY_DEC_NO | NUMBER(5, 0) | YES | ||
TRN_CRNCY_DT | DATE | YES | ||
PAY_CRNCY_CD | VARCHAR2(3) | YES | ||
PAY_CRNCY_NAME | VARCHAR2(35) | YES | ||
PAY_CRNCY_DT | DATE | YES | ||
TRN_TO_EUR_RT | NUMBER(28, 15) | YES | ||
EUR_TO_FUNC_RT | NUMBER(28, 15) | YES | ||
FUNC_TO_EUR_RT | NUMBER(28, 15) | YES | ||
EUR_TO_PAY_RT | NUMBER(28, 15) | YES | ||
TRN_TO_EUR_RT_FL | VARCHAR2(1) | YES | ||
FUNC_TO_EUR_RT_FL | VARCHAR2(1) | YES | ||
TRN_FREEZE_RT_FL | VARCHAR2(1) | YES | ||
PAY_FREEZE_RT_FL | VARCHAR2(1) | YES | ||
VAT_TAX_DT | DATE | YES | ||
VAT_TAX_ID | VARCHAR2(20) | YES |
X_Z_AOPUTLTE_ED4 Primary and Unique Keys |
Key Name | Key Type | Keys |
X_Z_AOPUTLTE_ED4 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 |