Pay Term

Table Name Pt_PtPrm_parameter_dtl

Table Comment This is the table in which parameter details of the pay term component are stored

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

PtPrm_ComponentName

varchar(80)

NOT NULL

This field holds the Name of the component.

Yes

No

PtPrm_ParamCategory

varchar(10)

NOT NULL

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

No

PtPrm_ParamType

varchar(25)

NOT NULL

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

No

PtPrm_ParamCode

varchar(5)

NOT NULL

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

No

PtPrm_Langid

numeric(10)

NOT NULL

Language id. This is the language id of the record.

Yes

No

PtPrm_ParamDesc

varchar(80)

NULL

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

No

PtPrm_CreationDate

datetime

NULL

This field holds the record created date for auditing purpose.

No

No

PtPrm_Sortby

numeric(10)

NULL

This field holds the default sort by code

No

No

Table Name Pt_PyTmDt_Payment_Term_Dtl

Table Comment This table contains the details of the payment term

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

PyTmDt_Created_OUInstance

numeric(10)

NOT NULL

This is the OU instance in which pay term codes are defined.

Yes

Yes

PyTmDt_Pay_Term_Code

varchar(25)

NOT NULL

This field is to capture the codes of the payment terms.

Yes

Yes

PyTmDt_Pay_Term_Line_Id

numeric(10)

NOT NULL

This is uniquely generated pay term line id

Yes

No

PyTmDt_Due_Days

decimal(28,8)

NULL

This field contains the no. of days before the payment due is made

No

No

PyTmDt_Due_Perc

decimal(28,8)

NULL

This field contains the due percentage before the payment due is made

No

No

PyTmDt_Discount_Days

decimal(28,8)

NULL

This field contains the no. of days before which if the payment is made,Discount will be allowed

No

No

PyTmDt_Discount_Perc

decimal(28,8)

NULL

This field exactly defines the discount percentage if the discount is allowed.

No

No

PyTmDt_Penalty_Perc

decimal(28,8)

NULL

This field exactly defines the penalty percentage.

No

No

PyTmDt_CreatedDate

datetime

NULL

This field is to capture the created date of the record

No

No

PyTmDt_Created_By

varchar(30)

NULL

This field is to capture the user who created the record

No

No

PyTmDt_ModifiedDate

datetime

NULL

This field is to capture the modified date of the record .

No

No

PyTmDt_Modified_By

varchar(30)

NULL

This field is to capture the user who modified the record

No

No

Table Name Pt_PyTmHd_Payment_Term_Hdr

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

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

PyTmHd_Created_OUInstance

numeric(10)

NOT NULL

This is the OU instance in which pay term codes are defined.

Yes

No

PyTmHd_Pay_Term_Code

varchar(25)

NOT NULL

This field is to capture the codes of the payment terms

Yes

No

PyTmHd_Pay_Term_Desc

varchar(80)

NULL

This field is to capture the description of the payment term

No

No

PyTmHd_Pay_Term_Desc_Up

varchar(80)

NULL

This field is to capture the upper case description of the payment term

No

No

PyTmHd_Pay_Term_Category

varchar(25)

NULL

This field is to capture one of the payment category codes defined in logistics common master component "B" - "Blank".

No

No

PyTmHd_Pay_Term_Type

varchar(5)

NULL

This field is to capture the payment type. Allowed values are "A" - "Advance", "N" - "Net" "B" - "Blank".

No

No

PyTmHd_Pay_Term_From_Date

datetime

NULL

This field is to capture the pay term effective from date.

No

No

PyTmHd_Pay_Term_To_Date

datetime

NULL

This field is to capture the pay term effective to date.

No

No

PyTmHd_Pay_Term_Status

varchar(5)

NULL

This field is to capture the status of the pay term. Allowed values are "A"- "Active", "I"- "Inactive", "B" - "Blank".

No

No

PyTmHd_Prop_Discount

varchar(5)

NULL

This field is to capture the proportional discount & values: "Y" - "Yes", "N" - "No".

No

No

PyTmHd_Anchor_Date

varchar(5)

NULL

This field is capture the reference date criteria for which the pay tem conditions are applied. Values are "M" - ’Manual’, "S"  - "Supplier Invoice Date", "O" - "Our doc date".

No

No

PyTmHd_Pay_Clsficatn

varchar(25)

NULL

This field is to capture the classification of the pay term. Allowed values are "Date"   "Date Based" "Days"   "Days Based"

No

No

PyTmHd_Pay_Frequency

varchar(20)

NULL

This field is to capture the frequency of the pay term. Allowed values are "Month"   "Month" "B"   "Space"

No

No

PyTmHd_CreatedDate

datetime

NULL

This field is to capture the created date of the record

No

No

PyTmHd_Created_By

varchar(30)

NULL

This field is to capture the user who created the record

No

No

PyTmHd_ModifiedDate

datetime

NULL

This field is to capture the modified date of the record .

No

No

PyTmHd_Modified_By

varchar(30)

NULL

This field is to capture the user who modified the record

No

No

PyTmHd_Timestamp

numeric(10)

NULL

This field is to capture the timestamp of the record

No

No