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.