PYMT_TRMS_TIME(SQL Table) |
Index Back |
|---|---|
Payment Terms Timing Defn |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | PAY_TRMS_TIME_ID |
Character(3) | VARCHAR2(3) NOT NULL |
Timing Definition ID
Prompt Table: PYMT_TRMS_TIME |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 5 | TMG_BASIS_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Timing Basis Option
F=Fixed Month/Day Values: M=End of Relative Month: N=None (Basis Date) S=Specific Due Date: Default Value: N |
| 6 | TMG_REL_MONTH_VAL | Signed Number(3,0) | DECIMAL(2) NOT NULL | End of Relative Month |
| 7 | TMG_MONTH_DUE_CD | Character(2) | VARCHAR2(2) NOT NULL |
Month Due
Prompt Table: TMG_MO_DUE_VW |
| 8 | TMG_DAY_DUE_CD | Character(2) | VARCHAR2(2) NOT NULL |
Day Due
Prompt Table: %EDITTABLE |
| 9 | DUE_DT | Date(10) | DATE | Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received. |
| 10 | TMG_DAY_INCR_VAL | Signed Number(4,0) | DECIMAL(3) NOT NULL | Day Increment |
| 11 | TMG_MONTH_INCR_VAL | Signed Number(3,0) | DECIMAL(2) NOT NULL | Month Increment |
| 12 | TMG_YEAR_INCR_VAL | Signed Number(3,0) | DECIMAL(2) NOT NULL | Year Increment |