Module List > Module Company/System tables SY00500
You are currently viewing the COMPANY database.
Change

COMPANY..SY00500 Table Definition

(COMPANY..Posting Definitions Master)

The SY00500 is unusual in that it is used slightly differently for each module.

Bill of Materials

Payables

Payables Management Payments Entry

Inventory:

Dynamics posting relies upon the Batch Activity File (SY_Batch_Activity_MSTR) and the 'Batch Status' field in the Posting Definitions Master File (Batch_Headers) to prevent users from accessing transactions that have been prepared for posting.

When a user selects a batch to post, Dynamics sets the 'Batch Status' field in the batch's corresponding Batch_Headers record to the constant BATCH_POSTING, indicating that the batch is ready for posting. At this point, the user cannot edit transactions in the batch unless they unmark the batch, at which time the status changes to OKAY. See the field values for 'Batch Status' in the following Field Descriptions for descriptions of these constants.

When posting starts, Dynamics adds an activity record to the SY_Batch_Activity_MSTR file, indicating that the batch is posting. This record also tracks the batch source, transaction source, and batch number for the batch. This record remains in the Dynamics system as long as the batch continues to post.

When posting and printing are complete, Dynamics removes the activity record from the SY_Batch_Activity_MSTR file (if the batch isn't recurring), and clears the 'Batch Status' field in the Batch_Headers record. No access violations will occur when a user is updating the transaction or any distributions associated with it, since the batch activity record locks all users out of the batch that's being posted.

Dynamics uses the Batch_Headers file according to the following guidelines:
- Marking a batch to post sets the Batch Status field to BATCH_POSTING, or 1. When a user begins posting transactions, Dynamics creates a batch activity record for the marked batch.
- The user can't delete or edit the batch or the transactions in the batch if the Batch Status field has a marked status (field values 1-3).
- When a user deletes a batch, it's important that you delete the batch header record last, since the flag on that record stops other users from accessing the batch.

How IV uses the Batch_Headers file
Each transaction in the IV_TRX_WORK_HDR file must be assigned to a batch. The batch header record for the batch should exist before any transactions are added to the work file for the batch. The 'Batch Status' of the batch header record should be set to BATCH_RECEIVING while any transactions are being added to the system from an outside source. Also, there should be a record added to the SY_Batch_Activity_MSTR file. This record should have the 'Posting' field set to true, thereby preventing other users from working in the batch until the transfer has been completed.


4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
GLPOSTDT datetime
'1/1/1900'
Date that ...(more) Join Now
BCHSOURC char(15)
''
Batch Sour...(more) Join Now
BACHNUMB char(15)
''
Batch Numb...(more) Join Now
SERIES smallint
0
Series: I...(more) Join Now
MKDTOPST tinyint
0
Marked To ...(more) Join Now
NUMOFTRX int
0
Number Of ...(more) Join Now
RECPSTGS smallint
0
Recurring ...(more) Join Now
DELBACH tinyint
0
Delete Bat...(more) Join Now
MSCBDINC smallint
0
Misc Batch...(more) Join Now
BACHFREQ smallint
0
Batch Freq...(more) Join Now
RCLPSTDT datetime
'1/1/1900'
Recurring ...(more) Join Now
NOFPSTGS smallint
0
Number of ...(more) Join Now
BCHCOMNT char(61)
''
Batch Comm...(more) Join Now
BRKDNALL tinyint
0
Break Down...(more) Join Now
CHKSPRTD tinyint
0
Payables: ...(more) Join Now
RVRSBACH tinyint
0

USERID char(15)
''
The user t...(more) Join Now
join ... more text available
CHEKBKID char(15)
''
Checkbook ID Checkbook this transaction affects
join ... more text available
BCHTOTAL numeric(19,5)
0.00
Batch Tota...(more) Join Now
BCHEMSG1 binary(4)
0
Batch Erro...(more) Join Now
BCHEMSG2 binary(4)
0
Batch Erro...(more) Join Now
BACHDATE datetime
'1/1/1900'

BCHSTRG1 char(21)
''
PM Manual ...(more) Join Now
BCHSTRG2 char(21)
''
PM Manual ...(more) Join Now
POSTTOGL tinyint
0
Post To GL...(more) Join Now
MODIFDT datetime
'1/1/1900'
Date the r...(more) Join Now
CREATDDT datetime
'1/1/1900'
Date this ...(more) Join Now RM00102.CREATDDT
NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
CURNCYID char(15)
''
Currency I...(more) Join Now
join ... more text available
BCHSTTUS smallint
0
Batch Stat...(more) Join Now
CNTRLTRX int
0
Control TR...(more) Join Now
CNTRLTOT numeric(19,5)
0.00
Payables: ...(more) Join Now
PETRXCNT smallint
0
Posting Er...(more) Join Now
APPROVL tinyint
0
Approval: ...(more) Join Now
APPRVLDT datetime
'1/1/1900'
Approval D...(more) Join Now
APRVLUSERID char(15)
''
Approval U...(more) Join Now
ORIGIN smallint
0

ERRSTATE int
0
Error Stat...(more) Join Now
GLBCHVAL binary(4)
0
GL Batch V...(more) Join Now
Computer_Check_Doc_Date datetime
'1/1/1900'
Payables: ...(more) Join Now
Sort_Checks_By smallint
0
Sort Check...(more) Join Now
SEPRMTNC tinyint
0
Separate R...(more) Join Now
REPRNTED smallint
0
Payables: ...(more) Join Now
CHKFRMTS smallint
0
Check Form...(more) Join Now
TRXSORCE char(13)
''
Transactio...(more) Join Now
PmtMethod smallint
0
Payment Me...(more) Join Now
EFTFileFormat smallint
0
EFT File F...(more) Join Now
Workflow_Approval_Status smallint
0
Time: Time...(more) Join Now
Workflow_Priority smallint
0
Workflow A...(more) Join Now
TIME1 datetime
'1/1/1900'
Time: Time...(more) Join Now
Workflow_Status smallint
0
1 Not Subm...(more) Join Now
ClearRecAmts tinyint
0

DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
PurchasingPrepaymentBch tinyint
0

CARDNAME char
''

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3