CBTRANSAUD

REFERENCED BY
CB295 CB95.2 CB95.1


UPDATED BY
AP170 AP180 AP181 AP190 AP255 AP265
AP81.1 AP90.5 CB00.2 CB06.2 CB10.1 CB145
CB15.1 CB15.2 CB150 CB180 CB185 CB186
CB187 CB190 CB191 CB20.1 CB20.6 CB25.1
CB30.1 CB305 CB46.1 CB500 CB543 CB544
CB80.1 CB82.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CAU-UNIQUE-I-D
Element: Unique I D
Bad Type 36
CAU-CASH-CODE
Element: Cash Code
Alpha 4
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB20.6
CB25.1 CB30.1
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CAU-BANK-INST-CODE
Element: Bank Inst Code
Alpha 3
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB20.6
CB25.1 CB30.1
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CAU-BANK-INST-TYPE
Element: Bank Inst Type
Alpha 1
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB20.6
CB25.1 CB30.1
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CAU-TRANS-NBR
Element: Trans Nbr
Alpha 10 (Right Justified)
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB20.6
CB25.1 CB30.1
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CAU-SUFFIX
Element: Suffix
Numeric 3
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB20.6
CB25.1 CB30.1
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CAU-TRANS-IDENT
Element: Trans Ident
Numeric 10
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB20.6
CB25.1 CB30.1
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CAU-COMPANY
Element: Company
Numeric 4
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB20.6
CB25.1 CB30.1
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CAU-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB20.6
CB25.1 CB30.1
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CAU-CUSTOMER
Element: Customer
Alpha 9 (Right Justified)
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB20.6
CB25.1 CB30.1
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CAU-EMPLOYEE
Element: Employee
Numeric 9
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB20.6
CB25.1 CB30.1
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CAU-APPROVER
Element: Approver
Alpha 30
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB20.6
CB25.1 CB30.1
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CAU-OPERATOR
Element: Operator
Alpha 10
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB20.6
CB25.1 CB30.1
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CAU-PERIOD-DATE
Element: Period Date
Numeric 8 (yyyymmdd)
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB20.6
CB25.1 CB30.1
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CAU-MAINT-DATE
Element: Maint Date
Numeric 8 (yyyymmdd)
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB20.6
CB25.1 CB30.1
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CAU-MAINT-TIME
Element: Maint Time
Numeric 6 (hhmmss)
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB20.6
CB25.1 CB30.1
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CAU-TRANS-DATE
Element: Trans Date
Numeric 8 (yyyymmdd)
CAU-TRANS-TIME
Element: Sys Time
Numeric 6 (hhmmss)
CAU-REC-STATUS
Element: Rec Status
Numeric 1
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
CB186 CB187
CB190 CB191
CB20.1 CB20.6
CB25.1 CB30.1
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1


CBTRANSAUD FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CAUSET1 BANK-INST-CODE
TRANS-IDENT
UNIQUE-I-D
KeyChange
CAUSET2 OPERATOR
MAINT-DATE
CASH-CODE
BANK-INST-CODE
TRANS-IDENT
REC-STATUS
UNIQUE-I-D
KeyChange
CB295 CB95.2
CAUSET3 CASH-CODE
MAINT-DATE
OPERATOR
BANK-INST-CODE
TRANS-NBR
TRANS-IDENT
REC-STATUS
UNIQUE-I-D
KeyChange
CB00.2 CB295
CB305 CB95.1
CAUSET4 VENDOR
MAINT-DATE
OPERATOR
BANK-INST-CODE
CASH-CODE
TRANS-NBR
TRANS-IDENT
UNIQUE-I-D
CAUSET5 CUSTOMER
MAINT-DATE
OPERATOR
CASH-CODE
COMPANY
BANK-INST-CODE
TRANS-IDENT
REC-STATUS
UNIQUE-I-D
KeyChange
CAUSET6 COMPANY
VENDOR
CUSTOMER
EMPLOYEE
MAINT-DATE
REC-STATUS
BANK-INST-CODE
TRANS-IDENT
CASH-CODE
UNIQUE-I-D
KeyChange
CAUUID UNIQUE-I-D
CB305


CBTRANSAUD FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Cbtrans CBTRANS Required
CAU-BANK-INST-CODE->CBT-BANK-INST-CODE
CAU-TRANS-IDENT->CBT-TRANS-IDENT


File created: Thu Jun 09 11:11:49 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.