CC_TRANS_PARM(SQL Table) |
Index Back |
|---|---|
ProCard AE Process Parameters |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | BILLING_DATE | Date(10) | DATE NOT NULL |
Billing Date
Prompt Table: %EDITTABLE |
| 4 | ECQUEUEINSTANCE | Number(9,0) | DECIMAL(9) NOT NULL | Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. |
| 5 | CREDIT_CARD_VENDOR | Character(5) | VARCHAR2(5) NOT NULL |
Corporate Card Vendor
Prompt Table:
CC_CARD_TBL_EX
|
| 6 | INCLUDE_TAX | Character(1) | VARCHAR2(1) NOT NULL |
Bill Includes Tax if Applied
Default Value: CC_CARD_TBL_EX.INCLUDE_TAX |
| 7 | DELETE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Delete Loaded Items
Y/N Table Edit |
| 8 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table: CC_BANK_ACT_VW |
| 9 | BANK_ACCT_KEY | Character(4) | VARCHAR2(4) NOT NULL |
A user defined unique identifier that facilitates the identification of a given account with a given bank
Prompt Table: CC_BANK_ACT_VW2 |
| 10 | BANK_ACCOUNT_NUM | Character(35) | VARCHAR2(35) NOT NULL |
The literal unique identifier associated with a given bank/counterparty account.
Prompt Table: CC_BANK_ACT_VW2 |
| 11 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_PM_NONVW |
| 12 | CC_POST_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Post and Payment Status
0=Not Processed 1=Initial Posted 2=Payment Created 3=Payment Posted 4=Final Posted 5=PO Posted 6=Voucher Build Error |