PM80100 - PM Batch Headers
Stores batch header information for payables batches including approval status.
SQL Query Builder
27 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| TRXSORCE | char(13) '' | ||||
| POSTEDDT | datetime '1/1/1900' | ||||
| GLPOSTDT | datetime '1/1/1900' | ||||
| BCHSOURC | char(15) '' | ||||
| BACHNUMB | char(15) '' | ||||
| CHEKBKID | char(15) '' | ||||
| NUMOFTRX | int 0 | ||||
| RECPSTGS | smallint 0 | ||||
| MSCBDINC | smallint 0 | ||||
| BACHFREQ | smallint 0 | ||||
Batch Frequency values (8) 1 = Single Use2 = Weekly3 = Biweekly4 = Semimonthly5 = Monthly6 = Bimonthly7 = Quarterly8 = Miscellaneous | |||||
| NOFPSTGS | smallint 0 | ||||
| BCHCOMNT | char(61) '' | ||||
| USERID | char(15) '' | ||||
| NOTEINDX | numeric(19,5) 0.00 | ||||
| RCDSRMVD | tinyint 0 | ||||
| BCHTOTAL | numeric(19,5) 0.00 | ||||
| CNTRLTRX | int 0 | ||||
| CNTRLTOT | numeric(19,5) 0.00 | ||||
| APPROVL | tinyint 0 | ||||
| APPRVLDT | datetime '1/1/1900' | ||||
| APRVLUSERID | char(15) '' | ||||
| Workflow_Approval_Status | smallint 0 | ||||
| Workflow_Priority | smallint 0 | ||||
| DEX_ROW_ID | int auto number (1,1) | ||||
| Workflow_Status | smallint 0 | ||||
| CREATDDT | datetime '1/1/1900' | ||||
| TIME1 | datetime '1/1/1900' | ||||
Reporting Tips
- - Contains batch approval information useful for audit trails
Related Tables
Tables that share columns with PM80100. Click "Join" to add to your query.