| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001 | BUKRS | Allow NULL? |
| 3 | CAJO_NUMBER | Cash Journal Number | nvarchar | 4 | 0 | CHAR | (N' ') | No | | CJNR | Allow NULL? |
| 4 | GL_ACCOUNT | G/L Account Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | SKB1 | SAKNR | Allow NULL? |
| 5 | CURRENCY | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 6 | DOC_TYPE_SK | Cash Journal Document Type: G/L Account Posting | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T003 | CJDOCTYPSK | Allow NULL? |
| 7 | DOC_TYPE_SO | Document Type for Cash Disbursements | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T003 | CJDOCTYPSO | Allow NULL? |
| 8 | DOC_TYPE_KZ | Cash Journal Document Type: Payment to Vendor | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T003 | CJDOCTYPKZ | Allow NULL? |
| 9 | DOC_TYPE_KG | Cash Journal Document Type: Payment from Vendor | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T003 | CJDOCTYPKG | Allow NULL? |
| 10 | DOC_TYPE_DZ | Cash Journal Document: Payment from Customer | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T003 | CJDOCTYPDZ | Allow NULL? |
| 11 | DOC_TYPE_DG | Cash Journal Document Type: Payment to Customer | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T003 | CJDOCTYPDG | Allow NULL? |
| 12 | BEGRU | Authorization Group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | BEGRU | Allow NULL? |
| 13 | PERSON1 | Cash Journal: Person 1 | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | CJPERSON1 | Allow NULL? |
| 14 | PERSON2 | Cash Journal: Person 2 | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | CJPERSON2 | Allow NULL? |
| 15 | TEXT | Additional Field for Cash Journal | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | CJCJTEXT30 | Allow NULL? |
| 16 | CJCLOSED | Indicator: Cash Journal Closed? | char | 1 | 0 | CHAR | (N' ') | Yes | | CJCLOSED | Allow NULL? |
| 17 | CHECKSUMSPLIT | Split Indicator for Totals Document During Check Deposit | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | CJCHECKSUMSPLIT | Allow NULL? |
| 18 | NUMBERING_OUT | Numbering Group for Payments | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TCJ_NUMB_GROUP | CJDNUMOUT | Allow NULL? |
| 19 | NUMBERING_IN | Numbering Group for Receipts | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TCJ_NUMB_GROUP | CJDNUMIN | Allow NULL? |
| 20 | NUMBERING_IN_CHE | Numbering Group for Check Receipts | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TCJ_NUMB_GROUP | CJDNUMINCHEQUE | Allow NULL? |
| 21 | CJSUBST | Indicator: Substitution in Cash Journal? | char | 1 | 0 | CHAR | (N' ') | Yes | | CJSUBST | Allow NULL? |
| 22 | CJSIMULTAN | Indicator: Simultaneous Cash Journal Access Permitted? | char | 1 | 0 | CHAR | (N' ') | Yes | | CJSIMULTAN | Allow NULL? |
