X_Z_AOPUTLAM_ED5 |
Default Table Name | X_Z_AOPUTLAM_ED5 |
Definition |
X_Z_AOPUTLAM_ED5 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(14, 2) | YES | ||
DISCOUNT_AMOUNT | NUMBER(14, 2) | YES | ||
DUE_AMOUNT | NUMBER(14, 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(14, 2) | YES | ||
CHECK_AMT | NUMBER(14, 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(14, 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(14, 2) | YES | ||
SALES_TAX_AMOUNT | NUMBER(14, 2) | YES | ||
LN_ACCT_DISC_AMT | NUMBER(14, 2) | YES | ||
NET_AMOUNT | NUMBER(14, 2) | YES | ||
USE_TAX_AMOUNT | NUMBER(14, 2) | YES | ||
BILL_LABR_CATEGORY | VARCHAR2(6) | YES | ||
GENL_LABR_CATEGORY | VARCHAR2(6) | YES | ||
VENDOR_HOURS | NUMBER(8, 2) | YES | ||
VENDOR_AMOUNT | NUMBER(14, 2) | YES | ||
VCHR_LN_VEND_KEY | NUMBER(10, 0) | YES | ||
NOTES | VARCHAR2(254) | YES | ||
LN_SALES_TAX_AMT | NUMBER(14, 2) | YES | ||
LN_USE_TAX_AMT | NUMBER(14, 2) | YES | ||
LN_DISC_AMT | NUMBER(14, 2) | YES | ||
QUANTITY | NUMBER(14, 2) | YES | ||
UNIT_CST_AMT | NUMBER(14, 2) | YES | ||
EXT_CST_AMT | NUMBER(14, 2) | YES | ||
DISCR_TOT_AMT | NUMBER(14, 2) | YES | ||
LN_CHG_CST_AMT | NUMBER(14, 2) | YES | ||
LN_CHG_TAX_AMT | NUMBER(14, 2) | YES | ||
LN_CHG_USE_TAX_AMT | NUMBER(14, 2) | YES | ||
VCHR_LN_ACCT_KEY | NUMBER(10, 0) | YES | ||
HDR_NOTES | VARCHAR2(254) | YES | ||
HOLD_VCHR_FL | VARCHAR2(1) | YES | ||
PROJ_ACCT_ABBRV_CD | VARCHAR2(6) | YES | ||
PRINT_NOTE_FL | VARCHAR2(1) | YES | ||
RECUR_TMPLT_FL | VARCHAR2(1) | YES | ||
VEND_EMPL_ID | VARCHAR2(12) | YES | ||
VEND_EMPL_NAME | VARCHAR2(25) | YES | ||
OVR_BUD_FL | VARCHAR2(1) | YES | ||
SHIP_AMT | NUMBER(14, 2) | YES | ||
S_INVC_TYPE | VARCHAR2(1) | YES | ||
PO_LN_NO | NUMBER(10, 0) | YES | ||
LN_ACCT_BEF_DISC | NUMBER(14, 2) | YES | ||
EFFECT_BILL_DATE | DATE | YES | ||
TRN_INVC_AMT | NUMBER(14, 2) | YES | ||
TRN_DISC_AMT | NUMBER(14, 2) | YES | ||
TRN_DUE_AMT | NUMBER(14, 2) | YES | ||
TRN_CST_AMT | NUMBER(14, 2) | YES | ||
TRN_SALES_TAX_AMT | NUMBER(14, 2) | YES | ||
TRN_USE_TAX_AMT | NUMBER(14, 2) | YES | ||
TRN_NET_AMT | NUMBER(14, 2) | YES | ||
TRN_VEND_AMT | NUMBER(14, 2) | YES | ||
TRN_RECOVERY_AMT | NUMBER(14, 2) | YES | ||
TRN_V_RECOVERY_AMT | NUMBER(14, 2) | YES | ||
TRN_LN_TAX_AMT | NUMBER(14, 2) | YES | ||
TRN_LN_USE_TAX_AMT | NUMBER(14, 2) | YES | ||
TRN_LN_DISC_AMT | NUMBER(14, 2) | YES | ||
TRN_UNIT_CST_AMT | NUMBER(14, 2) | YES | ||
TRN_EXT_CST_AMT | NUMBER(14, 2) | YES | ||
TRN_DISCR_TOT_AMT | NUMBER(14, 2) | YES | ||
TRN_LN_CHG_CST_AMT | NUMBER(14, 2) | YES | ||
TRN_LN_CHG_TAX_AMT | NUMBER(14, 2) | YES | ||
TRN_LN_CHG_USE_AMT | NUMBER(14, 2) | YES | ||
TRN_SHIP_AMT | NUMBER(14, 2) | YES |
X_Z_AOPUTLAM_ED5 Primary and Unique Keys |
Key Name | Key Type | Keys |
X_Z_AOPUTLAM_ED5 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 |