EM_VNDR_REG_TAO

(SQL Table)
Index Back

Temp Supplier Register Table

Temporary table used in the EM_ENABLE_AP process to register suppliers in the Buyer Direct model.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SETID_TBL

3 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
4 EM_VCHR_PROC Character(1) VARCHAR2(1) NOT NULL Voucher Processing
0=Specify Buyers
1=All Buyers

Y/N Table Edit

Default Value: N

5 EM_CASH_COL_NOT Character(1) VARCHAR2(1) NOT NULL Cash Collections Access

Y/N Table Edit

Default Value: N

6 EM_RPT_ACCESS Character(1) VARCHAR2(1) NOT NULL Reporting Access Allowed

Y/N Table Edit

Default Value: N

7 EM_NOT_VCHR_PD Character(1) VARCHAR2(1) NOT NULL Voucher Paid Notification

Y/N Table Edit

Default Value: N

8 EM_BANNER_MNGT_FLG Character(1) VARCHAR2(1) NOT NULL No Banner Management

Y/N Table Edit

Default Value: N

9 EM_SELL_INFO1_FLG Character(1) VARCHAR2(1) NOT NULL Supplier Information Flag 1

Y/N Table Edit

Default Value: N

10 EM_SELL_INFO2_FLG Character(1) VARCHAR2(1) NOT NULL Supplier Information Flag 2

Y/N Table Edit

Default Value: N

11 EM_ERP_INTG_XML Character(1) VARCHAR2(1) NOT NULL ERP Integration File

Y/N Table Edit

Default Value: N

12 EM_REPORT_TYPE Character(1) VARCHAR2(1) NOT NULL Report Type
F=Fixed Format
X=XML File

Default Value: X

13 EM_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Extract Frequency
B=Bi weekly
D=Daily
M=Monthly
W=Weekly
Y=Yearly
14 EM_VCHR_EXT_STATUS Character(2) VARCHAR2(2) NOT NULL Invoice Extract Status
AP=Approved
MA=Matched and Approved
MP=Matched and Pending Approval
PA=Pending Approval
PD=Paid
X=Any Status Change