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.