 |
Lawson Insight Technical Documentation |
|
CBDISTRIB FILE
Transaction Distribution
The Transaction Distribution file contains all distribution records
associated with a Cash Ledger transaction.
REFERENCED BY
CB195 CB221 CB99.1
UPDATED BY
AP170 AP180 AP181 AP190 AP255 AP265
AP81.1 AP90.5 AR115 AR124 AR20.1 AR21.1
AR21.2 AR21.3 AR24.1 AR30.1 AR30.2 AR30.4
AR570 AR575 AR580 AR82.1 CB06.2 CB10.1
CB15.1 CB15.2 CB175 CB180 CB185 CB190
CB191 CB20.1 CB30.1 CB300 CB500 CB80.1
DT180 DT181 DT185 DT92.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CBD-CASH-CODE Alpha 4 AP170 AP180
Cash Code The cash code. Represents a bank AP181 AP190
account. Must be a valid record in the AP255 AP265
Cash Code file. AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR30.2 AR30.4
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB15.1 CB15.2
CB180 CB185
CB190 CB191
CB20.1 CB30.1
CB500 CB80.1
DT180 DT181
DT185 DT92.1
CBD-BANK-INST-CODE Alpha 3 AP170 AP180
Transaction Code The transaction code. Represents a type AP181 AP190
of cash payment, bill of exchange AP255 AP265
payment, or bank service transaction. AP81.1 AP90.5
Must be a valid record in the Bank AR115 AR124
Transaction Code file. AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR30.2 AR30.4
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB15.1 CB15.2
CB180 CB185
CB190 CB191
CB20.1 CB30.1
CB500 CB80.1
DT180 DT181
DT185 DT92.1
CBD-TRANS-IDENT Numeric 10 AP170 AP180
Transaction ID A unique system-generated AP181 AP190
identification value assigned to the AP255 AP265
transaction to make this record unique. AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR30.2 AR30.4
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB15.1 CB15.2
CB180 CB185
CB190 CB191
CB20.1 CB30.1
CB500 CB80.1
DT180 DT181
DT185 DT92.1
CBD-TRANS-NBR Alpha 10 (Right Justified) AP170 AP180
Transaction Number The unique number used to identify the AP181 AP190
transaction. Must be a valid record in AP255 AP265
the Bank Transaction file. AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR30.2 AR30.4
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB15.1 CB15.2
CB180 CB185
CB190 CB191
CB20.1 CB30.1
CB500 CB80.1
DT180 DT181
DT185 DT92.1
CBD-SUFFIX Numeric 3 AP170 AP180
Transaction Suffix The transaction suffix number. AP181 AP190
Represents the occurrence value of the AP255 AP265
transaction. AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR30.2 AR30.4
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB15.1 CB15.2
CB180 CB185
CB190 CB191
CB20.1 CB30.1
CB500 CB80.1
DT180 DT181
DT185 DT92.1
CBD-SOURCE-CODE Alpha 2 AP170 AP180
Source Code Identifies where the bank transaction AP181 AP190
was created. Valid values are: AP255 AP265
AP81.1 AP90.5
AP = Accounts Payable. AR115 AR124
AR = Accounts Receivable. AR20.1 AR21.1
CB = Cash Ledger. AR21.2 AR21.3
AR24.1 AR30.1
AR30.2 AR30.4
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB15.1 CB15.2
CB180 CB185
CB190 CB191
CB20.1 CB30.1
CB500 CB80.1
DT180 DT181
DT185 DT92.1
CBD-COMPANY Numeric 4 AP170 AP180
Company The company number that initiated or AP181 AP190
created the transaction. Must be a valid AP255 AP265
record in the General Ledger Company AP81.1 AP90.5
file. AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR30.2 AR30.4
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB15.1 CB15.2
CB180 CB185
CB190 CB191
CB20.1 CB30.1
CB500 CB80.1
DT180 DT181
DT185 DT92.1
CBD-SEQ-NBR Numeric 4 AP170 AP180
Sequence Number Contains a system-assigned sequence AP181 AP190
number. AP255 AP265
AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR30.2 AR30.4
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB15.1 CB15.2
CB180 CB185
CB190 CB191
CB20.1 CB30.1
CB500 CB80.1
DT180 DT181
DT185 DT92.1
CBD-DIST-COMPANY Numeric 4 AP170 AP180
Distribution Company The company number the bank transaction AP181 AP190
is to be posted to. Must be a valid AP255 AP265
record in the General Ledger Company AP81.1 AP90.5
file. AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR30.2 AR30.4
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB15.1 CB15.2
CB180 CB185
CB190 CB191
CB20.1 CB30.1
CB500 CB80.1
DT180 DT181
DT185 DT92.1
CBD-DIST-TYPE Alpha 1 AP170 AP180
Distribution Type The distribution type. Valid values are: AP181 AP190
AP255 AP265
E = Entry. AP81.1 AP90.5
R = Reconciliation. AR115 AR124
V = Cash Ledger Void Update AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR30.2 AR30.4
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB15.1 CB15.2
CB180 CB185
CB190 CB191
CB20.1 CB30.1
CB500 CB80.1
DT180 DT181
DT185 DT92.1
CBD-RECORD-TYPE Alpha 1 AP170 AP180
Record Type Identifies the type of distribution AP181 AP190
record. Valid values are: AP255 AP265
AP81.1 AP90.5
C = Cash Account Distribution. AR115 AR124
Blank = Not a cash account distribution. AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR30.2 AR30.4
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB15.1 CB15.2
CB180 CB185
CB190 CB191
CB20.1 CB30.1
CB500 CB80.1
DT180 DT181
DT185 DT92.1
CBD-REC-STATUS Numeric 1 AP170 AP180
Record Status The status of the transaction AP181 AP190
distribution. Valid values are: AP255 AP265
AP81.1 AP90.5
0 = Unreleased. AR115 AR124
1 = Released. AR20.1 AR21.1
9 = Posted. AR21.2 AR21.3
AR24.1 AR30.1
AR30.2 AR30.4
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB15.1 CB15.2
CB175 CB180
CB185 CB190
CB191 CB20.1
CB30.1 CB500
CB80.1 DT180
DT181 DT185
DT92.1
CBD-POST-DATE Numeric 8 (yyyymmdd) AP170 AP180
General Ledger The date for using to post the AP181 AP190
Posting Date transaction to the general ledger. AP255 AP265
AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR30.2 AR30.4
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB15.1 CB15.2
CB180 CB185
CB190 CB191
CB20.1 CB30.1
CB500 CB80.1
DT180 DT181
DT185 DT92.1
CBD-DIS-ACCT-UNIT Alpha 15 AP170 AP180
Accounting Unit The general ledger distribution AP181 AP190
accounting unit. Must be a valid record AP255 AP265
in the General Ledger Names file. AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR30.2 AR30.4
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB15.1 CB15.2
CB180 CB185
CB190 CB191
CB20.1 CB30.1
CB500 CB80.1
DT180 DT181
DT185 DT92.1
CBD-DIS-ACCOUNT Numeric 6 AP170 AP180
Account Number The general ledger distribution account AP181 AP190
number. Must be a valid record in the AP255 AP265
General Ledger Account Master file. AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR30.2 AR30.4
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB15.1 CB15.2
CB180 CB185
CB190 CB191
CB20.1 CB30.1
CB500 CB80.1
DT180 DT181
DT185 DT92.1
CBD-DIS-SUB-ACCT Numeric 4 AP170 AP180
Subaccount Number The general ledger distribution AP181 AP190
subaccount number. Must be a valid AP255 AP265
record in the General Ledger Account AP81.1 AP90.5
Master file. AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR30.2 AR30.4
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB15.1 CB15.2
CB180 CB185
CB190 CB191
CB20.1 CB30.1
CB500 CB80.1
DT180 DT181
DT185 DT92.1
CBD-ACT-CNV-RATE Signed 12.6 AP170 AP180
Exchange Rate The currency exchange rate used to AP181 AP190
convert the bank account currency AP255 AP265
distribution amount to the company base AP81.1 AP90.5
currency. AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR30.2 AR30.4
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB15.1 CB15.2
CB180 CB185
CB190 CB191
CB20.1 CB30.1
CB500 CB80.1
DT180 DT181
DT185 DT92.1
CBD-BANK-DIST-AMT Signed 15.2 AP170 AP180
Acct Currency The distribution amount in the currency AP181 AP190
Distribution Amt of the bank account. AP255 AP265
AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR30.2 AR30.4
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB15.1 CB15.2
CB180 CB185
CB190 CB191
CB20.1 CB30.1
CB500 CB80.1
DT180 DT181
DT185 DT92.1
CBD-ORIG-BASE-AMT Signed 15.2 AP170 AP180
Base Currency The distribution amount in the base AP181 AP190
Distribution Amt currency of the originating company. AP255 AP265
AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR30.2 AR30.4
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB15.1 CB15.2
CB180 CB185
CB190 CB191
CB20.1 CB30.1
CB500 CB80.1
DT180 DT181
DT185 DT92.1
CBD-DIST-BASE-AMT Signed 15.2 AP170 AP180
To Company The distribution amount in the base AP181 AP190
Distribution Amount currency of the distribution company. AP255 AP265
AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR30.2 AR30.4
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB15.1 CB15.2
CB180 CB185
CB190 CB191
CB20.1 CB30.1
CB500 CB80.1
DT180 DT181
DT185 DT92.1
CBD-TO-BNK-DST-AMT Signed 15.2 AP170 AP180
To Acct Curr The distribution amount in the currency AP181 AP190
Distribution Amt of the to bank account. AP255 AP265
AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR30.2 AR30.4
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB15.1 CB15.2
CB180 CB185
CB190 CB191
CB20.1 CB30.1
CB500 CB80.1
DT180 DT181
DT185 DT92.1
CBD-REFERENCE Alpha 10 (Lower Case) AP170 AP180
Reference The reference value assigned to the AP181 AP190
transaction distribution. Used for AP255 AP265
informational purposes. AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR30.2 AR30.4
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB15.1 CB15.2
CB180 CB185
CB190 CB191
CB20.1 CB30.1
CB500 CB80.1
DT180 DT181
DT185 DT92.1
CBD-DESCRIPTION Alpha 30 (Lower Case) AP170 AP180
Description The description of the transaction AP181 AP190
distribution. AP255 AP265
AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR30.2 AR30.4
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB15.1 CB15.2
CB180 CB185
CB190 CB191
CB20.1 CB30.1
CB500 CB80.1
DT180 DT181
DT185 DT92.1
CBD-ACTIVITY Alpha 15 AP170 AP180
Activity The activity assigned to the bank AP181 AP190
transaction distribution. Must be a AP255 AP265
valid record in the Activity Header AP81.1 AP90.5
file. AR115 AR124
AR20.1 AR21.1
Activities are the tasks that make up AR21.2 AR21.3
an activity group. Activities identify AR24.1 AR30.1
work being done, such as work orders, AR30.2 AR30.4
phases, products, and so on. A variety AR570 AR575
of costs, revenues, or both make up an AR580 AR82.1
activity. CB06.2 CB10.1
CB15.1 CB15.2
CB180 CB185
CB190 CB191
CB20.1 CB30.1
CB500 CB80.1
DT180 DT181
DT185 DT92.1
CBD-TAX-CODE Alpha 10 CB10.1 CB180
Tax Code The tax code to be applied to the bank CB20.1 CB30.1
transaction distribution. Must be a CB500
valid record in the Tax Code file.
CBD-TRAN-TAXABLE Signed 15.2 CB10.1 CB180
Taxable Amount The taxable amount of the bank CB20.1 CB30.1
transaction distribution in the currency CB500
of the bank account.
CBD-TAX-TYPE Alpha 1 CB180 CB20.1
Tax Type If a Tax Code is present, this field CB30.1 CB500
indicates the type of tax. Valid values
are:
I = Invoiced. The tax amount is
included in the transaction amount.
CBD-TO-BASE-ND Numeric 1 AP170 AP180
To Base Number Of The number of decimal places defined AP181 AP190
Decimals for the base currency of the AP255 AP265
distribution company. AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR30.2 AR30.4
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB15.1 CB15.2
CB180 CB185
CB190 CB191
CB20.1 CB30.1
CB500 CB80.1
DT180 DT181
DT185 DT92.1
CBD-TO-TRAN-ND Numeric 1 AP170 AP180
To Transaction Nbr The number of decimal places defined AP181 AP190
of Decimals for the currency of the to bank account. AP255 AP265
AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR30.2 AR30.4
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB15.1 CB15.2
CB180 CB185
CB190 CB191
CB20.1 CB30.1
CB500 CB80.1
DT180 DT181
DT185 DT92.1
CBD-TRAN-ND Numeric 1 AP170 AP180
Transaction Number The number of decimal places defined AP181 AP190
of Decimals for the base currency of the originating AP255 AP265
company. AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR30.2 AR30.4
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB15.1 CB15.2
CB180 CB185
CB190 CB191
CB20.1 CB30.1
CB500 CB80.1
DT180 DT181
DT185 DT92.1
CBD-BASE-ND Numeric 1 AP170 AP180
Base Currency Nbr The number of decimal places defined AP181 AP190
of Decimals for the currency of the bank account. AP255 AP265
AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR30.2 AR30.4
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB15.1 CB15.2
CB180 CB185
CB190 CB191
CB20.1 CB30.1
CB500 CB80.1
DT180 DT181
DT185 DT92.1
CBD-GLT-OBJ-ID Numeric 12 AP170 AP180
Subsystem GL This is a subsystem GL interface AP181 AP190
Interface ID identification number. It is used for AP255 AP265
Drill Around purposes. AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR30.2 AR30.4
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB15.1 CB15.2
CB175 CB180
CB185 CB190
CB191 CB20.1
CB30.1 CB500
CB80.1 DT180
DT181 DT185
DT92.1
CBD-ACT-OBJ-ID Numeric 12 AP170 AP180
Subsystem Activity A subsystem activity interface AP181 AP190
InterfaceID identification number. Used for Drill AP255 AP265
Around purposes. AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR30.2 AR30.4
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB15.1 CB15.2
CB175 CB180
CB185 CB190
CB191 CB20.1
CB30.1 CB500
CB80.1 DT180
DT181 DT185
DT92.1
CBD-ACCT-CATEGORY Alpha 5 CB10.1 CB191
Account Category The account category assigned to the CB20.1 CB30.1
bank transaction distribution. Must be a
valid record in the Activity Account
Category file.
Account categories are the Activity
Management accounts by which activity
transactions are grouped for budgeting
and reporting.
CBD-ANALYSIS-FLD Alpha 32 CB20.1 CB30.1
Analysis Field The user-defined analysis field
assigned to the bank transaction
distribution.
CBD-RECON-STMT-NBR Numeric 12
Reconciliation The bank-assigned reconciliation
Statement statement number. Used only for cash
codes that require reconciliation
statements.
CBDISTRIB FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CBDSET1 CASH-CODE The index is used to group all general AP170 AP180
BANK-INST-CODEledger distributions for a bank AP181 AP190
TRANS-IDENT transaction. AP255 AP265
DIST-TYPE AP81.1 AP90.5
SEQ-NBR AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR30.2 AR30.4
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB15.1 CB15.2
CB175 CB180
CB185 CB190
...
CBDSET2 DIST-COMPANY This index is used to sequence general
DIS-ACCT-UNIT ledger distributions by general ledger
DIS-ACCOUNT account number.
DIS-SUB-ACCT KeyChange
GLT-OBJ-ID
CASH-CODE
TRANS-NBR
BANK-INST-CODE
DIST-TYPE
SEQ-NBR
TRANS-IDENT
CBDSET3 ACT-OBJ-ID This index is used to show the
CASH-CODE committed cost in Cash Ledger for the
BANK-INST-CODEActivity Management system.
TRANS-IDENT KeyChange, Subset
DIST-TYPE Where ACT-OBJ-ID != Zeroes
SEQ-NBR
CBDSET4 COMPANY KeyChange CB175
REC-STATUS
CASH-CODE
BANK-INST-CODE
TRANS-IDENT
DIST-TYPE
SEQ-NBR
CBDISTRIB FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Cbbankent CBBANKENT Required
CBC-BANK-ENTITY -> CBE-BANK-ENTITY
Cbcashcode CBCASHCODE Required
CBD-CASH-CODE -> CBC-CASH-CODE
Cbstatemnt CBSTATEMNT Not Required
Valid When CBD-RECON-STMT-NBR != Zeroes
CBD-CASH-CODE -> CSM-CASH-CODE
CBD-RECON-STMT-NBR -> CSM-RECON-STMT-NBR
Cbstmtdtl CBSTMTDTL Required
When CBD-RECON-STMT-NBR != Zeroes
CBD-BANK-INST-CODE -> CSD-BANK-INST-CODE
CBD-RECON-STMT-NBR -> CSD-RECON-STMT-NBR
CBD-TRANS-NBR -> CSD-PAYMENT-NBR
"G" -> CSD-TRANS-TYPE
Cbtrans CBTRANS Required
CBD-BANK-INST-CODE -> CBT-BANK-INST-CODE
CBD-TRANS-IDENT -> CBT-TRANS-IDENT
Glmaster GLMASTER Required
CBD-DIST-COMPANY -> GLM-COMPANY
CBD-DIS-ACCT-UNIT -> GLM-ACCT-UNIT
CBD-DIS-ACCOUNT -> GLM-ACCOUNT
CBD-DIS-SUB-ACCT -> GLM-SUB-ACCOUNT
Glsystem GLSYSTEM Required
CBD-DIST-COMPANY -> GLS-COMPANY
Glsystem Orig GLSYSTEM Required
CBD-COMPANY -> GLS-COMPANY
|