CB_GENCLAIM_AET(SQL Table) |
Index Back |
---|---|
Claimbacks Batch AE |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
4 | CB_RUN_BY | Character(1) | VARCHAR2(1) NOT NULL |
Run Process By
C=Single Claimback Contract S=Claimback SetID V=Supplier ID Default Value: S |
5 | CB_CONTRACT_SETID | Character(5) | VARCHAR2(5) NOT NULL | Claimback Contract Setid |
6 | CB_CONTRACT_ID | Character(25) | VARCHAR2(25) NOT NULL |
Claimback Contract ID
Prompt Table: CB_HDR |
7 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: VENDOR |
8 | CB_CREATE_CLAIMS | Character(1) | VARCHAR2(1) NOT NULL |
Create Claimback Claims
Y/N Table Edit Default Value: Y |
9 | CB_CREATE_ACCR | Character(1) | VARCHAR2(1) NOT NULL |
Accrue Claimback Revenue
Y/N Table Edit Default Value: N |
10 | FROM_DATE | Date(10) | DATE | From Date |
11 | AS_OF_DATE | Date(10) | DATE | As of Date |
12 | CB_CLAIM_PREFIX | Character(3) | VARCHAR2(3) NOT NULL |
Claim Prefix
Prompt Table: CB_CLAIMSEQ_VW |
13 | BASE_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. " |
14 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. |
15 | SCHEDULE_ID | Character(10) | VARCHAR2(10) NOT NULL | Schedule ID |
16 | DTTM_STAMP | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |