P 2 K_PR_PAYMENT_RULE_DETAILS
Back to current versionRestore this version

Alias: PPRD#

(P2K_PR_PAYMENT_RULE_DETAILS)

Unique Keys:
Child Table:
Parent Table: P2K_PR_PAYMENT_RULES
ERD: ERD-PR30


Payment Rule Details

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
PPR_IDNumber(10)IDYlink to P2K_PR_PAYMENT_RULES
PBL_IDNumber(10)ID link to P2K_PR_BANK_LOCATIONS
PPRD_IDNumber(10)ID link to P2K_PR_PAYMENT_RULE_DETAILS
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CREATE_DATEDate()DATEY
PAYMENT_RULE_TYPEVarchar2(2)X_PAYMENT_RULE_TYPEY
BANK_ACCOUNTVarchar2(30)VARCHAR30
BANK_ACCOUNT_TYPEVarchar2(2)X_BANK_ACCT_TYPE
SPLIT_SEQUENCENumber(5)NUMBER5
AMOUNTNumber(18)AMT12V6
NET_PAY_PERCENTNumber(5)PERCENT
PAY_REMAININGVarchar2(1)TOGGLE
PAID_TO_ORDER_OFVarchar2(50)VARCHAR50
DEPOSIT_START_DATEDate()DATE
PRENOTE_REQUIREDVarchar2(1)TOGGLE
PRENOTE_DATEDate()DATE
PRIME_DEPOSITVarchar2(1)TOGGLE

User Fields: Allowed
Audit Logging: Allowed


Notes #

Click to create a new notes page