GP Tables

JC01301 - JC_Production_Batch_Headers

SQL Query Builder

39 Columns

Column Description Type Length
GLPOSTDT datetime
BCHSOURC char(15)
BACHNUMB char(15)
SERIES smallint
Module Series values (8)
1 = All2 = Financial3 = Sales4 = Purchasing5 = Inventory6 = Payroll7 = Project10 = 3rd Party
MKDTOPST tinyint
NUMOFTRX int
RECPSTGS smallint
DELBACH tinyint
MSCBDINC smallint
BACHFREQ smallint
Batch Frequency values (8)
1 = Single Use2 = Weekly3 = Biweekly4 = Semimonthly5 = Monthly6 = Bimonthly7 = Quarterly8 = Miscellaneous
RCLPSTDT datetime
NOFPSTGS smallint
BCHCOMNT char(61)
BRKDNALL tinyint
CHKSPRTD tinyint
RVRSBACH tinyint
USERID char(15)
CHEKBKID char(15)
BCHTOTAL numeric(19,5)
BCHEMSG1 binary(4)
BCHEMSG2 binary(4)
BACHDATE datetime
BCHSTRG1 char(21)
BCHSTRG2 char(21)
POSTTOGL tinyint
MODIFDT datetime
CREATDDT datetime
NOTEINDX numeric(19,5)
CURNCYID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. char(15)
BCHSTTUS smallint
CNTRLTRX int
CNTRLTOT numeric(19,5)
Production_Control_Total numeric(19,5)
PETRXCNT smallint
APPROVL tinyint
APPRVLDT datetime
APRVLUSERID char(15)
ORIGIN smallint
DEX_ROW_ID int auto number (1,1)

Related Tables

Tables that share columns with JC01301. Click "Join" to add to your query.

DEX_ROW_ID

AAG00200 AAG00201 AAG00202 AAG00300 AAG00301 AAG00302 ACColumn AF00100

MODIFDT

ASIEXP01 ASIEXP02 ASIEXP03 ASIEXP04 ASIEXP06 ASIEXP07 ASIEXP09 ASIEXP11

USERID

AAG50001 AAG60001 AAG70001 ACTIVITY AHPSLH01 APR_APR30000 APR_APR30300 ASIEXP100

NOTEINDX

AAG00201 AAG00300 AAG00400 AAG00401 AF40100 AF40103 AF40106 APR_BLM42100

CURNCYID

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 AAG50001 AAG60001

BACHNUMB

APR_APR30000 ASIEXP06 ASIEXP08 ASIEXP09 ASIEXP10 ASIEXP12 ASIEXP19 ASIEXP20