|
Code:
- CREATE TABLE TAXSTMTP (
- -- Field Name Type Size Defaults
- CORP# DECIMAL (6, 0) DEFAULT 0,
- CUST# DECIMAL (6, 0) DEFAULT 0,
- PRDLVL CHAR (1) DEFAULT ' ',
- SVCLVL CHAR (1) DEFAULT ' ',
- BSLVL CHAR (1) DEFAULT ' ',
- BTN# VARCHAR (50) ALLOCATE(25) NOT NULL DEFAULT ' ',
- DEPT# DECIMAL (4, 0) DEFAULT 0,
- PAC# DECIMAL (8, 0) DEFAULT 0,
- SUMTYP CHAR (1) DEFAULT ' ',
- TAXABL DECIMAL (15, 6) DEFAULT 0,
- TAXCDE DECIMAL (10, 0) DEFAULT 0,
- TAXLVL CHAR (1) DEFAULT ' ',
- TAXAMT DECIMAL (13, 6) DEFAULT 0,
- TXRATE DECIMAL (11, 6) DEFAULT 0,
- PCODE DECIMAL (10, 0) DEFAULT 0,
- TRNTYP DECIMAL (10, 0) DEFAULT 0,
- SVCTYP DECIMAL (10, 0) DEFAULT 0,
- CALCTYP DECIMAL (10, 0) DEFAULT 0,
- TXMEAS DECIMAL (12, 6) DEFAULT 0,
- EXMPTAMT DECIMAL (12, 6) DEFAULT 0,
- EXMPTFLGS CHAR (4) DEFAULT ' ',
- FLAG10 CHAR (10) DEFAULT ' ',
- FLAG1 CHAR (1) DEFAULT ' ',
- FLAG2 CHAR (1) DEFAULT ' ',
- EXTRAMT DECIMAL (13, 6) DEFAULT 0,
- APITYPE CHAR (1) DEFAULT ' ',
- LINES DECIMAL (7, 0) DEFAULT 0,
- INTL_TS CHAR (1) DEFAULT ' ',
- DESC CHAR (20) DEFAULT ' ',
- BdlChgId DECIMAL (10, 0) NOT NULL DEFAULT 0)
-
- RCDFMT TAXSTMTF;
-
- LABEL ON TABLE TAXSTMTP
- IS 'Tax Statement Records';
-
- -- COLUMN HEADINGS.
- -- TO GET THESE TO COME OUT VISUALLY PLEASANT, EACH LINE IS 20A.
- -- HEADING1............HEADING2............HEADING3............
- LABEL ON COLUMN Taxstmtp (
- CORP# IS 'Corporate Number',
- CUST# IS 'Customer Number' ,
- PRDLVL IS 'Product Level' ,
- SVCLVL IS 'Service Level' ,
- BSLVL IS 'Bill Sum Level' ,
- BTN# IS 'Billing Tele#' ,
- DEPT# IS 'Department No.' ,
- PAC# IS 'Accounting Code' ,
- SUMTYP IS 'Summary Type' ,
- TAXABL IS 'Amt Subject to Tax' ,
- TAXCDE IS 'Tax Code' ,
- TAXLVL IS 'Tax Level' ,
- TAXAMT IS 'Tax Amount' ,
- TXRATE IS 'Tax Rate' ,
- PCODE IS 'Pcode' ,
- TRNTYP IS 'B.S. Transaction Type' ,
- SVCTYP IS 'B.S. Service Type' ,
- CALCTYP IS 'Calc Type' ,
- TXMEAS IS 'Taxable Measure' ,
- EXMPTAMT IS 'Exempt Amount' ,
- EXMPTFLGS IS 'Exempt Flags' ,
- FLAG10 IS 'Flags' ,
- FLAG1 IS 'Flag 1' ,
- FLAG2 IS 'Flag 2' ,
- EXTRAMT IS 'Extra Amount' ,
- APITYPE IS 'B.S. API Type' ,
- LINES IS 'Number of Lines',
- INTL_TS IS 'International T/S',
- DESC IS 'Description',
- BdlChgId IS 'Bundle Charge Id'
- );
|
|