PAY_TRMS_TBL (SQL Table)	Index Back
Payment Terms Defn Header Payment Terms Definition header - values of this table are synced up with that of FSCM corresponding table

PAY_TRMS_TBL

(SQL Table)

Payment Terms Defn Header

Payment Terms Definition header - values of this table are synced up with that of FSCM corresponding table

Related Language Record: PAY_TRMS_TBL_LG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

2 PYMNT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

5 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

7 PYMNT_TERMS_DT Character(1) VARCHAR2(1) NOT NULL Payment Terms Basis Date. This field was brought over from Supply Chain.
1=User Date 1
2=User Date 2
A=As of Date
I=Accounting Date
N=Invoice Date

8 PYMNT_TERMS_AMT Character(1) VARCHAR2(1) NOT NULL Payment Terms Basis Amount
1=User Amount 1
2=User Amount 2
G=Gross Voucher Amount
I=Item Amount
V=VAT Discountable Amount
Default Value: I

9 PS_SYSTEM Character(2) VARCHAR2(2) NOT NULL PeopleSoft Applications. This field was brought over from Supply Chain Management.
AM=Asset Management
AP=Accounts Payable
AR=Accounts Receivable
GL=General Ledger
HR=Human Resources/Payroll
PM=Purchasing Management

10 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

11 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.

12 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

13 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

14 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

15 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables. Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	PYMNT_TERMS_CD	Character(5)	VARCHAR2(5) NOT NULL	Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
5	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
6	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
7	PYMNT_TERMS_DT	Character(1)	VARCHAR2(1) NOT NULL	Payment Terms Basis Date. This field was brought over from Supply Chain. 1=User Date 1 2=User Date 2 A=As of Date I=Accounting Date N=Invoice Date
8	PYMNT_TERMS_AMT	Character(1)	VARCHAR2(1) NOT NULL	Payment Terms Basis Amount 1=User Amount 1 2=User Amount 2 G=Gross Voucher Amount I=Item Amount V=VAT Discountable Amount Default Value: I
9	PS_SYSTEM	Character(2)	VARCHAR2(2) NOT NULL	PeopleSoft Applications. This field was brought over from Supply Chain Management. AM=Asset Management AP=Accounts Payable AR=Accounts Receivable GL=General Ledger HR=Human Resources/Payroll PM=Purchasing Management
10	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
11	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
12	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
13	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
14	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
15	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time