X_AR_RECEIPT_SETUP |
Default Table Name | X_AR_RECEIPT_SETUP |
Definition |
X_AR_RECEIPT_SETUP Columns |
ColumnName | Domain | Datatype | NULL | Definition |
FILE_FORMAT_CD | VARCHAR2(6) | YES | ||
TRANS_SET_CD | VARCHAR2(3) | YES | ||
SEGMENT_DELIMITER_CD | VARCHAR2(1) | YES | ||
ELEMENT_DELIMITER_CD | VARCHAR2(1) | YES | ||
HARD_RETURNS_FL | VARCHAR2(1) | YES | ||
ALIAS_MATCH_FL | VARCHAR2(1) | YES | ||
CUST_DEFAULT_FL | VARCHAR2(1) | YES | ||
DEFAULT_CUST_ID | VARCHAR2(12) | YES | ||
USE_BANK_INVC_ID_FL | VARCHAR2(1) | YES | ||
USE_UNK_INVC_ID_FL | VARCHAR2(1) | YES | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
COMPANY_ID![]() |
VARCHAR2(10) | NO | ||
ROWVERSION | NUMBER(10, 0) | YES | ||
DUP_DIFF_CUST_FL | VARCHAR2(1) | YES | ||
DUP_DIFF_CUST_CD | VARCHAR2(6) | YES | ||
DUP_SAME_CUST_FL | VARCHAR2(1) | YES | ||
DUP_SAME_CUST_CD | VARCHAR2(6) | YES | ||
INVC_LIKE_MATCH_FL | VARCHAR2(1) | YES | ||
INVC_AMT_MATCH_FL | VARCHAR2(1) | YES | ||
INVC_AMT_PRI | NUMBER(5, 0) | YES | ||
BAL_DUE_MATCH_FL | VARCHAR2(1) | YES | ||
BAL_DUE_PRI | NUMBER(5, 0) | YES | ||
CUST_NAME_MATCH_FL | VARCHAR2(1) | YES | ||
CUST_NAME_PRI | NUMBER(5, 0) | YES | ||
BILL_NO_MATCH_FL | VARCHAR2(1) | YES | ||
BILL_NO_PRI | NUMBER(5, 0) | YES |
X_AR_RECEIPT_SETUP Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_7151 | PrimaryKey | COMPANY_ID |
X_AR_RECEIPT_SETUP 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 |