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 |