| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PSARCH_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Archive ID (see PSARCHTEMPLATE).
|
| 2 |
PSARCH_BATCHNUM |
Number(30,0) |
DECIMAL(30) NOT NULL |
Archive Batch Number
|
| 3 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: VENDOR_LOC.SETID
|
| 4 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
Default Value: VENDOR_LOC.VENDOR_ID
|
| 5 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
Default Value: VENDOR_LOC.VNDR_LOC
|
| 6 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 7 |
WTHD_ENTITY |
Character(5) |
VARCHAR2(5) NOT NULL |
Withholding Entity
Prompt Table:
WTHD_ENTITY_DFN
|
| 8 |
WTHD_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Withholding Type
Prompt Table:
WTHD_TYPE_TBL
|
| 9 |
WTHD_JUR_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Withholding Jurisdiction
Prompt Table:
WTHD_JUR_TBL
|
| 10 |
DEFAULT_CLASS |
Character(5) |
VARCHAR2(5) NOT NULL |
Default Withholding Class
Prompt Table:
WTHD_CLASS_TBL
|
| 11 |
WTHD_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Withhold Rule Indicator
D=Default from Entity Definition
S=Specify at this Level
Default Value: D
|
| 12 |
WTHD_RULE |
Character(5) |
VARCHAR2(5) NOT NULL |
Withholding Rule
Prompt Table:
WTHD_RULE_HDR
|
| 13 |
HOLD_PAY_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Hold Pay Indicator
D=Default from Entity Definition
S=Specify at this Level
Default Value: D
|
| 14 |
HOLD_PAY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Hold Payment
B=Hold wthd & regular payment
N=Do Not Hold
W=Hold Withholding only
Default Value: N
|
| 15 |
WTHD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Withhold if missing
N=Don't withholding
Y=Withholdeable
Default Value: Y
|
| 16 |
DEFAULT_JUR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Jurisdiction
N=Not Default Jur
Y=Default Jur
|
| 17 |
VENDOR_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor Category
Default Value: WTHD_VNDR_CATVW.VENDOR_CATEGORY
Prompt Table:
WTHD_VNDR_CAT
|
| 18 |
WTHD_CONDITION |
Character(1) |
VARCHAR2(1) NOT NULL |
Withholding Condition
E=Exonerate
N=Not Applicable
X=Exempt
Default Value: N
|
| 19 |
CONDITION_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Condition %
|
| 20 |
CONDITION_UNTIL |
Date(10) |
DATE |
Condition Valid Until
|
| 21 |
REMIT_WTHD_TO_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Remit Withhold to Flag
E=Entity
V=Supplier
Default Value: E
|
| 22 |
REMIT_VENDOR |
Character(10) |
VARCHAR2(10) NOT NULL |
Remit Vendor
Prompt Table:
VNDR_RETURN_VW
|
| 23 |
REMIT_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Remit to Location
Prompt Table:
VNDR_REM_LOC_VW
|
| 24 |
REMIT_ADDR_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Remitting Location
Prompt Table:
VNDR_REMADDR_VW
|