PRT_ACCOSCSH

Database

SDSNZS01_PRT

Schema

CDCPADM_PRT

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY SMALLINT 2
2 SUBCOY SMALLINT 2
3 STATE SMALLINT 2
4 BRANCH SMALLINT 2
5 OSCSHTYPE CHARACTER(1) 1
6 TRANNO INTEGER 4
7 SEQUENCE SMALLINT 2
8 CASHTYPE CHARACTER(1) 1
9 AMOUNT NUMERIC(11,2) 19
10 AGENT INTEGER 4
11 PRODUCT CHARACTER(3) 3
12 POLICY INTEGER 4
13 CLIENT INTEGER 4
14 CLAIMNO NUMERIC(11,0) 19
15 GLCOMPANY SMALLINT 2
16 GLSTATE SMALLINT 2
17 GLBRANCH SMALLINT 2
18 ACCTCODE INTEGER 4
19 AREARESP SMALLINT 2
20 COMMAMT NUMERIC(11,2) 19
21 NAME CHARACTER(40) 40
22 TRANDATE INTEGER 4
23 LOCKUSER CHARACTER(8) 8
24 LOCKDATE INTEGER 4
25 LOCKTIME INTEGER 4
26 INVOICE INTEGER 4
27 USERID CHARACTER(8) 8
28 USERALLOC CHARACTER(1) 1
29 CUSTREF CHARACTER(14) 14
30 RECOVTYPE CHARACTER(2) 2
31 PAYMNTTYP CHARACTER(2) 2
32 CLTDETAIL CHARACTER(30) 30
33 BUSUNIT CHARACTER(4) 4
34 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
35 RECORD_TYPE CHARACTER VARYING(16) 16
36 COMMIT_TIMESTAMP TIMESTAMP 8
37 EXTRACT_TIMESTAMP TIMESTAMP 8