SY00500 - Posting Definitions Master | Prospr

SY00500 - Posting Definitions Master

Query Builder

Select * from SY00500

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
GLPOSTDT	GL Posting Date	Date	4	View
BCHSOURC	Batch Source	String	16	View
BACHNUMB	Batch Number	String	16	View
SERIES	Series 1 = All 2 = Financial 3 = Sales 4 = Purchasing 5 = Inventory 6 = Payroll - USA 7 = Project	Integer	2	View
MKDTOPST	Marked To Post	Boolean	2	View
NUMOFTRX	Number Of TRX	Long Integer	4	View
RECPSTGS	Recurring Postings	Integer	2	View
DELBACH	Delete Batch	Boolean	2	View
MSCBDINC	Misc Batch Days To Increment	Integer	2	View
BACHFREQ	Batch Frequency 1 = Single Use 2 = Weekly 3 = Biweekly 4 = Semi monthly 5 = Monthly 6 = Bi Monthly 7 = Quarterly 8 = Miscellaneous	Integer	2	View
RCLPSTDT	Recurring Last Posted Date	Date	4	View
NOFPSTGS	Number of Postings	Integer	2	View
BCHCOMNT	Batch Comment	String	62	View
BRKDNALL	Break Down Alloc	Boolean	2	View
CHKSPRTD	Checks Printed	Boolean	2	View
RVRSBACH	Reverse Batch	Boolean	2	View
USERID	User ID	String	16	View
CHEKBKID	Checkbook ID	String	16	View
BCHTOTAL	Batch Total	Currency	10	View
BCHEMSG1	Batch Error Messages 1	Long Integer	4	View
BCHEMSG2	Batch Error Messages 2	Long Integer	4	View
BACHDATE	Batch Date	Date	4	View
BCHSTRG1	Batch String 1	String	22	View
BCHSTRG2	Batch String 2	String	22	View
POSTTOGL	Post To GL	Boolean	2	View
MODIFDT	Modified Date	Date	4	View
CREATDDT	Created Date	Date	4	View
NOTEINDX	Note Index	Currency	10	View
CURNCYID	Currency ID	String	16	View
BCHSTTUS	Batch Status	Integer	2	View
CNTRLTRX	Control TRX Count	Long Integer	4	View
CNTRLTOT	Control Total	Currency	10	View
PETRXCNT	Posting Error TRX Count	Integer	2	View
APPROVL	Approval	Boolean	2	View
APPRVLDT	Approval Date	Date	4	View
APRVLUSERID	Approval User ID	String	16	View
ORIGIN	Origin	Integer	2	View
ERRSTATE	Error State	Long Integer	4	View
GLBCHVAL	GL Batch Valid	Long Integer	4	View
Computer_Check_Doc_Date	Computer Check Document Date	Date	4	View
Sort_Checks_By	Sort Checks By	Integer	2	View
SEPRMTNC	Seperate Remittance	Boolean	2	View
REPRNTED	Reprinted	Integer	2	View
CHKFRMTS	Check Formats	Integer	2	View
TRXSORCE	TRX Source	String	14	View
PmtMethod	Payment Method	Integer	2	View
EFTFileFormat	EFT File Format	Integer	2	View
Workflow_Approval_Status	Workflow Approval Status 1 – Not Submitted 2 – Submitted 3 – No Approval Needed 4 – Pending Approval 5 – Pending Changes 6 – Approved 7 – Rejected 8 – Workflow Ended 9 – Workflow Not Activated 10 – Workflow Deactivated	Integer	2	View
Workflow_Priority	Workflow Priority	Integer	2	View
TIME1	Time	Time	4	View
ClearRecAmts	Clear Recurring Amounts	Boolean	2	View
PurchasingPrepaymentBch	Purchasing Prepayment Batch	Boolean	2	View

SY00500 - Posting Definitions Master

Query Builder

Customer Service

Information

My Account

Contact Us