Data Dictionary -- Pay Term

Srl. No.	Table Name	Comment
1	PT_PTPRM_PARAMETER_DTL	This is the table in which parameter details of the payterm component are stored
2	PT_PYTMDT_PAYMENT_TERM_DTL	This table contains the details of the payment term
3	PT_PYTMHD_PAYMENT_TERM_HDR	This is the table in which payterm code definition details are maintained

Table Name :	PT_PTPRM_PARAMETER_DTL
Comment :	This is the table in which parameter details of the payterm component are stored

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PTPRM_COMPONENTNAME	_varchar_80	varchar(80)	No	This field holds the Name of the component.	Yes
PTPRM_PARAMCATEGORY	_varchar_10	varchar(10)	No	This field will capture the category of the static value. The static values could be to fill up combo, text field, guidance text, combo default etc.	Yes
PTPRM_PARAMTYPE	_varchar_25	Varchar(25)	No	Normally param type is the name of the control. This will allow us to store all the possible values for a combo in multiple rows.	Yes
PTPRM_PARAMCODE	_varchar_5	varchar(5)	No	This is the code that may be used for data storage. This is valid only incase of combo boxes. Here the short code that will be stored as data in the transaction could be maintained.	Yes
PTPRM_LANGID	_decimal_10_0	decimal(10)	No	Language id. This is the language id of the record.	Yes
PTPRM_PARAMDESC	_varchar_80	varchar(80)	Yes	Param description is the values to be filled in the combo box or guidance text. This is actually the meta data of this component	No
PTPRM_CREATIONDATE	_datetime_8	datetime(8)	Yes	This field holds the record created date for auditing purpose.	No
PTPRM_SORTBY	_decimal_10_0	decimal(10)	Yes	This field holds the default sort by code	No

Table Name :	PT_PYTMDT_PAYMENT_TERM_DTL
Comment :	This table contains the details of the payment term

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PYTMDT_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	This is the ouinstance in which payterm codes are defined.	Yes
PYTMDT_PAY_TERM_CODE	_varchar_25	Varchar(25)	No	This field is to capture the codes of the payment terms.	Yes
PYTMDT_PAY_TERM_LINE_ID	_decimal_10_0	decimal(10)	No	This is uniquely generated pay term line id	Yes
PYTMDT_DUE_DAYS	_decimal_28_8	decimal(28)	Yes	This field contains the no.of days before the payment due is made	No
PYTMDT_DUE_PERC	_decimal_28_8	decimal(28)	Yes	This field contains the due percentage before the payment due is made	No
PYTMDT_DISCOUNT_DAYS	_decimal_28_8	decimal(28)	Yes	This field contains the no.of days before which if the payment is made,Discount will be allowed	No
PYTMDT_DISCOUNT_PERC	_decimal_28_8	decimal(28)	Yes	This field exactly defines the discount percentage if the discount is allowed.	No
PYTMDT_PENALTY_PERC	_decimal_28_8	decimal(28)	Yes	This field exactly defines the penalty percentage.	No
PYTMDT_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field is to capture the created date of the record	No
PYTMDT_CREATED_BY	_varchar_30	varchar(30)	Yes	This field is to capture the user who created the record	No
PYTMDT_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field is to capture the modified date of the record .	No
PYTMDT_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field is to capture the user who modified the record	No

Table Name :	PT_PYTMHD_PAYMENT_TERM_HDR
Comment :	This is the table in which payterm code definition details are maintained

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PYTMHD_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	This is the ouinstance in which payterm codes are defined.	Yes
PYTMHD_PAY_TERM_CODE	_varchar_25	Varchar(25)	No	This field is to capture the codes of the payment terms	Yes
PYTMHD_PAY_TERM_DESC	_varchar_80	varchar(80)	Yes	This field is to capture the description of the payment term	No
PYTMHD_PAY_TERM_DESC_UP	_varchar_80	varchar(80)	Yes	This field is to capture the upper case description of the payment term	No
PYTMHD_PAY_TERM_CATEGORY	_varchar_25	Varchar(25)	Yes	This field is to capture one of the payment category codes defined in logistics common mster component "B" - "Blank".	No
PYTMHD_PAY_TERM_TYPE	_varchar_5	varchar(5)	Yes	This field is to capture the payment type. Allowed values are "A" - "Advance", "N" - "Net" "B" - "Blank".	No
PYTMHD_PAY_TERM_FROM_DATE	_datetime_8	datetime(8)	Yes	This field is to capture the payterm effective from date.	No
PYTMHD_PAY_TERM_TO_DATE	_datetime_8	datetime(8)	Yes	This field is to capture the payterm effective to date.	No
PYTMHD_PAY_TERM_STATUS	_varchar_5	varchar(5)	Yes	This field is to capture the status of the payterm. Allowed values are "A"- "Active", "I"- "Inactive", "B" - "Blank".	No
PYTMHD_PROP_DISCOUNT	_varchar_5	varchar(5)	Yes	This field is to capture the proportional discount values: "Y" - "Yes", "N" - "No".	No
PYTMHD_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field is to capture the created date of the record	No
PYTMHD_CREATED_BY	_varchar_30	varchar(30)	Yes	This field is to capture the user who created the record	No
PYTMHD_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field is to capture the modified date of the record .	No
PYTMHD_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field is to capture the user who modified the record	No
PYTMHD_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	This field is to capture the timestamp of the record	No
PYTMHD_ANCHOR_DATE	_varchar_5	varchar(5)	Yes	This field is capture the reference date criteria for which the paytem conditions are applied. Values are "M" - Manual , "S" - "Supplier Invoice Date", "O" - "Our doc date".	No
PYTMHD_PAY_Clsficatn	_varchar_25	Varchar(25)	Yes	This field is to capture the clasification of the payterm. Allowed values are "Date" "Date Based" "Days" "Days Based"	No
PYTMHD_PAY_Frequency	_varchar_20	varchar(20)	Yes	This field is to capture the frequency of the payterm. Allowed values are "Month" "Month" "B" "Space"	No