AR_DOCUMENT_FORMAT_DETAILS

AR Document Format Details

tableFINAR

AR_DOCUMENT_FORMAT_DETAILS — AR Document Format Details. FIN table in the standard Ross ERP 8.0 schema: 8 columns, used by 7 programs. Columns, data types, keys, foreign keys and relationships.

Open AR_DOCUMENT_FORMAT_DETAILS in the interactive Data Dictionary →

Part of AR tables & objects · all tables, views & procedures

Columns

#ColumnTypeKeyDescription
1GEM_DBKEYintGEMBASE internal surrogate primary key: a system-generated unique row identifier (the database key). Not a business field; every table carries one.
2AR_DOCUMENT_FORMATvarchar(6)PKAR Document Format Code
3AR_DOCUMENT_FORMAT_SEQUENCEsmallintPK
4AR_DOCUMENT_SORT_FIELDvarchar(31)
5AR_DOCUMENT_BREAK_HDR_MSGvarchar(6)
6AR_DOCUMENT_BREAK_FOOT_MSGvarchar(6)
7AR_DOCUMENT_BREAKvarchar(1)Document Break Point Indicator
8AR_DOCUMENT_MEMO_BREAKvarchar(1)Memo Break Field