EM_VNDR_REG_TAO(SQL Table) |
Index Back |
---|---|
Temp Supplier Register TableTemporary 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 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance | |
2 | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SETID_TBL |
|
3 | 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 |