SYS_EDI_CREDIT_TERMS_XREF
EDI Credit Terms Cross Reference
tableFINSYS
SYS_EDI_CREDIT_TERMS_XREF — EDI Credit Terms Cross Reference. FIN table in the standard Ross ERP 8.0 schema: 19 columns, used by 5 programs. Columns, data types, keys, foreign keys and relationships.
Open SYS_EDI_CREDIT_TERMS_XREF in the interactive Data Dictionary →Part of SYS tables & objects · all tables, views & procedures
Columns
| # | Column | Type | Key | Description |
|---|---|---|---|---|
| 1 | GEM_DBKEY | int | GEMBASE internal surrogate primary key: a system-generated unique row identifier (the database key). Not a business field; every table carries one. | |
| 2 | COMPANY_CODE | varchar(10) | PK | Company Code |
| 3 | CREDIT_TERMS_CODE | varchar(6) | PK | Credit Terms Code |
| 4 | DAYS_ALLOWED | smallint | Days Allowed for Discount | |
| 5 | SEQUENCE | smallint | PK | Sequence Number |
| 6 | SYS_EDI_TERMS_TYPE | varchar(2) | EDI Terms Type Code | |
| 7 | SYS_EDI_TERMS_BASIS_DATE | varchar(2) | EDI Terms Basis Date Code | |
| 8 | SYS_EDI_TERMS_DISC_PERCENT | varchar(6) | EDI Terms Discount Percent | |
| 9 | SYS_EDI_TERMS_DISC_DUE_DATE | varchar(6) | EDI Terms Discount Due Date | |
| 10 | SYS_EDI_TERMS_DISC_DAYS_DUE | varchar(3) | EDI Terms_discount Days Due | |
| 11 | SYS_EDI_TERMS_NET_DUE_DATE | varchar(6) | EDI Terms Net Due Date | |
| 12 | SYS_EDI_TERMS_DISC_AMOUNT | varchar(10) | EDI Terms Discount Amount | |
| 13 | SYS_EDI_DEFERRED_DUE_DATE | varchar(6) | EDI Deferred Due Date | |
| 14 | SYS_EDI_DEFERRED_AMOUNT_DUE | varchar(10) | EDI Deferred Amount Due | |
| 15 | SYS_EDI_PERCENT_INVOICE | varchar(5) | EDI Percent of Invoice Payable | |
| 16 | SYS_EDI_TERMS_DAY_OF_MONTH | varchar(2) | EDI Terms Day of Month | |
| 17 | SYS_EDI_PAYMENT_METHOD_CODE | varchar(1) | EDI Payment Method Code | |
| 18 | SYS_EDI_TERMS_PERCENT | varchar(10) | EDI Terms Percent | |
| 19 | SYS_EDI_TERMS_NET_DAYS | varchar(3) | EDI Terms Net Days |