[Home] [Help] [Dependency Information]
Object Name: | AP_AUD_RULE_SETS# |
---|---|
Object Type: | VIEW |
Owner: | AP |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RULE_SET_ID | NUMBER | (15) | Yes | |
RULE_SET_NAME | VARCHAR2 | (60) | Yes | |
RULE_SET_TYPE | VARCHAR2 | (30) | Yes | |
DESCRIPTION | VARCHAR2 | (240) | ||
START_DATE | DATE | |||
END_DATE | DATE | |||
PAPERLESS_AUDIT_CC_ONLY_FLAG | VARCHAR2 | (1) | ||
PAPERLESS_AUDIT_VIOLATION_FLAG | VARCHAR2 | (1) | ||
PAPERLESS_AUDIT_PDM_ONLY_FLAG | VARCHAR2 | (1) | ||
ASSIGN_AUDITOR_STAGE_CODE | VARCHAR2 | (30) | ||
AUDIT_ALL_VIOLATIONS_FLAG | VARCHAR2 | (1) | ||
AUDIT_ALL_FROM_AUDIT_LIST_FLAG | VARCHAR2 | (1) | ||
AUDIT_ALL_OLD_RECEIPTS_FLAG | VARCHAR2 | (1) | ||
AUDIT_ALL_RECEIPT_DAYS_LIMIT | NUMBER | |||
RANDOM_AUDIT_FLAG | VARCHAR2 | (1) | ||
RANDOM_AUDIT_PERCENTAGE | NUMBER | |||
IGNORE_CREDIT_ONLY_FLAG | VARCHAR2 | (1) | ||
IGNORE_RJ_NOT_REQ_ONLY_FLAG | VARCHAR2 | (1) | ||
AUTO_APPROVAL_TAG | VARCHAR2 | (80) | ||
REQUIRES_AUDIT_TAG | VARCHAR2 | (80) | ||
PAPERLESS_AUDIT_TAG | VARCHAR2 | (80) | ||
RECEIPT_DELAY_RULE_FLAG | VARCHAR2 | (1) | ||
RECEIPT_DELAY_DAYS | NUMBER | |||
MONTHLY_TOTAL_RULE_FLAG | VARCHAR2 | (1) | ||
MONTHLY_TOTAL_ALLOWED | NUMBER | |||
MONTHLY_VIOLATIONS_RULE_FLAG | VARCHAR2 | (1) | ||
MONTHLY_VIOLATIONS_ALLOWED | NUMBER | |||
MONTHLY_REPORTS_RULE_FLAG | VARCHAR2 | (1) | ||
MONTHLY_REPORTS_ALLOWED | NUMBER | |||
AUDIT_TERM_DURATION_DAYS | NUMBER | |||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
NOTIFY_RCT_OVERDUE_DAYS | NUMBER | |||
NOTIFY_ACTION_REQUIRED_DAYS | NUMBER | |||
NOTIFY_DOCUMENT_REQUIRED_CODE | VARCHAR2 | (30) | ||
NOTIFY_RESPONSE_OVERDUE_DAYS | NUMBER | |||
NOTIFY_RCT_RECEIVED_CODE | VARCHAR2 | (30) | ||
HOLD_CODE | VARCHAR2 | (30) | ||
HOLD_RCT_OVERDUE_DAYS | NUMBER | |||
HOLD_RCT_OVERDUE_BP_CC_CODE | VARCHAR2 | (30) | ||
AUDIT_ALL_AMOUNT_CODE | VARCHAR2 | (30) | ||
AUDIT_ALL_AMOUNT_LIMIT | NUMBER | |||
AUDIT_ALL_AMOUNT_CURRENCY_CODE | VARCHAR2 | (15) | ||
AUDIT_ALL_RECEIPTS_CODE | VARCHAR2 | (30) | ||
AUDIT_ALL_JUSTIFICATION_CODE | VARCHAR2 | (30) | ||
AUDIT_ALL_INACTIVE_CODE | VARCHAR2 | (30) | ||
AUDIT_ALL_UNUSED_ADVANCES | VARCHAR2 | (30) | ||
CASH_LIMIT_ENABLED | VARCHAR2 | (1) | ||
CASH_LIMIT | NUMBER | |||
CARD_LIMIT_ENABLED | VARCHAR2 | (1) | ||
CARD_LIMIT | NUMBER | |||
MILEAGE_LIMIT_ENABLED | VARCHAR2 | (1) | ||
MILEAGE_LIMIT | NUMBER | |||
ALLOW_NEGATIVE_LINES | VARCHAR2 | (1) | ||
IMAGE_RECEIPT_REQ | VARCHAR2 | (1) | ||
ORIG_RECEIPT_REQ | VARCHAR2 | (1) | ||
IMAGE_PREV_SUB_FLAG | VARCHAR2 | (240) | ||
IMAGE_REQ_JUST_FLAG | VARCHAR2 | (240) | ||
IMAGE_REQ_APPR_FLAG | VARCHAR2 | (1) | ||
NOTIFY_IMG_RCT_OVERDUE_DAYS | NUMBER | |||
NOTIFY_IMG_ACTION_REQ_DAYS | NUMBER | |||
NOTIFY_IMG_RESP_OVERDUE_DAYS | NUMBER | |||
AUD_IMG_RECEIPT_REQUIRED | VARCHAR2 | (1) | ||
AUD_PAPER_RECEIPT_REQUIRED | VARCHAR2 | (1) | ||
RECPT_ASSIGN_STAGE_CODE | VARCHAR2 | (240) | ||
IMAGE_AUDIT_TAG | VARCHAR2 | (80) | ||
CURRENCY_CODE | VARCHAR2 | (15) | ||
ALLOW_RECPT_DECL | VARCHAR2 | (1) | ||
REQ_REAPPR_FLAG | VARCHAR2 | (1) | ||
ALLOW_RECPT_MISSING | VARCHAR2 | (1) | ||
PAYABLES_IMAGE_REQ | VARCHAR2 | (1) | ||
AUDIT_ALL | VARCHAR2 | (1) | ||
AUDIT_SPECIFIC | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT RULE_SET_ID
, RULE_SET_NAME
, RULE_SET_TYPE
, DESCRIPTION
, START_DATE
, END_DATE
, PAPERLESS_AUDIT_CC_ONLY_FLAG
, PAPERLESS_AUDIT_VIOLATION_FLAG
, PAPERLESS_AUDIT_PDM_ONLY_FLAG
, ASSIGN_AUDITOR_STAGE_CODE
, AUDIT_ALL_VIOLATIONS_FLAG
, AUDIT_ALL_FROM_AUDIT_LIST_FLAG
, AUDIT_ALL_OLD_RECEIPTS_FLAG
, AUDIT_ALL_RECEIPT_DAYS_LIMIT
, RANDOM_AUDIT_FLAG
, RANDOM_AUDIT_PERCENTAGE
, IGNORE_CREDIT_ONLY_FLAG
, IGNORE_RJ_NOT_REQ_ONLY_FLAG
, AUTO_APPROVAL_TAG
, REQUIRES_AUDIT_TAG
, PAPERLESS_AUDIT_TAG
, RECEIPT_DELAY_RULE_FLAG
, RECEIPT_DELAY_DAYS
, MONTHLY_TOTAL_RULE_FLAG
, MONTHLY_TOTAL_ALLOWED
, MONTHLY_VIOLATIONS_RULE_FLAG
, MONTHLY_VIOLATIONS_ALLOWED
, MONTHLY_REPORTS_RULE_FLAG
, MONTHLY_REPORTS_ALLOWED
, AUDIT_TERM_DURATION_DAYS
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, NOTIFY_RCT_OVERDUE_DAYS
, NOTIFY_ACTION_REQUIRED_DAYS
, NOTIFY_DOCUMENT_REQUIRED_CODE
, NOTIFY_RESPONSE_OVERDUE_DAYS
, NOTIFY_RCT_RECEIVED_CODE
, HOLD_CODE
, HOLD_RCT_OVERDUE_DAYS
, HOLD_RCT_OVERDUE_BP_CC_CODE
, AUDIT_ALL_AMOUNT_CODE
, AUDIT_ALL_AMOUNT_LIMIT
, AUDIT_ALL_AMOUNT_CURRENCY_CODE
, AUDIT_ALL_RECEIPTS_CODE
, AUDIT_ALL_JUSTIFICATION_CODE
, AUDIT_ALL_INACTIVE_CODE
, AUDIT_ALL_UNUSED_ADVANCES
, CASH_LIMIT_ENABLED
, CASH_LIMIT
, CARD_LIMIT_ENABLED
, CARD_LIMIT
, MILEAGE_LIMIT_ENABLED
, MILEAGE_LIMIT
, ALLOW_NEGATIVE_LINES
, IMAGE_RECEIPT_REQ
, ORIG_RECEIPT_REQ
, IMAGE_PREV_SUB_FLAG
, IMAGE_REQ_JUST_FLAG
, IMAGE_REQ_APPR_FLAG
, NOTIFY_IMG_RCT_OVERDUE_DAYS
, NOTIFY_IMG_ACTION_REQ_DAYS
, NOTIFY_IMG_RESP_OVERDUE_DAYS
, AUD_IMG_RECEIPT_REQUIRED
, AUD_PAPER_RECEIPT_REQUIRED
, RECPT_ASSIGN_STAGE_CODE
, IMAGE_AUDIT_TAG
, CURRENCY_CODE
, ALLOW_RECPT_DECL
, REQ_REAPPR_FLAG
, ALLOW_RECPT_MISSING
, PAYABLES_IMAGE_REQ
, AUDIT_ALL
, AUDIT_SPECIFIC
FROM AP.AP_AUD_RULE_SETS#;
|
|
|