# LANGUAGE: Language codes - Name: `LANGUAGE` - Catalog: `AccountView` - Label: Language codes - Partition-specific: true - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `LANGUAGE` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ADV_DESC` | `string(40)` | Advance invoice settlement description | ☐ | | | `AI_DESC` | `string(4)` | Additional AutoInvoice email text | ☐ | | | `CI_MAILTM` | `string(10)` | Counter sales invoice email template | ☐ | | | `CNG_DATE` | `datetime` | Date modified | ☐ | | | `CNG_NR` | `int32` | Change number | ☐ | | | `CNG_USR` | `string(20)` | Employee last modified | ☐ | | | `CPY_BCK1` | `string(200)` | First background image copy document | ☐ | | | `CPY_BCK2` | `string(200)` | Second background image copy documents | ☐ | | | `DATE_MAIL` | `string(240)` | Delivery date change email layout | ☐ | | | `DEAR` | `string(20)` | Attn description | ☐ | | | `DEL_MAIL` | `string(240)` | Shipping confirmation email layout | ☐ | | | `DJ_EINV` | `string(3)` | Bank details for electronic invoicing | ☐ | | | `DP_MAILTM` | `string(10)` | Down payment email template | ☐ | | | `INP_DATE` | `datetime` | Entry date | ☐ | | | `INP_USR` | `string(20)` | Entered by employee | ☐ | | | `LAY_INPS` | `string(240)` | Inventory page packing slip layout | ☐ | | | `LAY_POC` | `string(240)` | Purchase order layout | ☐ | | | `LAY_REM1` | `string(240)` | Payment reminder 1 layout | ☐ | | | `LAY_REM2` | `string(240)` | Payment reminder 2 layout | ☐ | | | `LAY_REM3` | `string(240)` | Payment reminder 3 layout | ☐ | | | `LAY_SBS` | `string(240)` | Subscription layout | ☐ | | | `LAY_SICI` | `string(240)` | Counter sales invoice layout | ☐ | | | `LAY_SISI` | `string(240)` | Sales invoice layout | ☐ | | | `LAY_SOLB` | `string(240)` | Shipping label layout | ☐ | | | `LAY_SOOC` | `string(240)` | Sales order confirmation layout | ☐ | | | `LAY_SOPS` | `string(240)` | Packing slip layout | ☐ | | | `LAY_SOSL` | `string(240)` | Consignment note layout | ☐ | | | `LAY_SPLB` | `string(240)` | Shipping label layout | ☐ | | | `LAY_SPPL` | `string(240)` | Packing list layout | ☐ | | | `LAY_SPPS` | `string(240)` | Packing slip layout | ☐ | | | `LAY_SPSL` | `string(240)` | Consignment note layout | ☐ | | | `LAY_STMT` | `string(240)` | Open items statement layout | ☐ | | | `LNG_CODE` | `string(5)` | Language code | ☐ | | | `LNG_DESC` | `string(40)` | Language code description | ☐ | | | `ORD_MAIL` | `string(240)` | Order confirmation email layout | ☐ | | | `partition_code` | `string` | Partition code | ☑ | | | `partition_name` | `string` | Partition name | ☑ | | | `PB_DESC` | `string(20)` | PO box description | ☐ | | | `PO_COLD` | `string(40)` | Consolidated purchase order description | ☐ | | | `PO_DESC` | `string(4)` | Consolidated purchase lines description | ☐ | | | `PO_MAILTM` | `string(10)` | Purchase order email template | ☐ | | | `PS_MAILTM` | `string(10)` | Packing slip email template | ☐ | | | `QT_TPL` | `string(10)` | Std text layout | ☐ | | | `REM_ATTN` | `string(80)` | Accounts payable administration | ☐ | | | `REM_MAILTM` | `string(10)` | Payment reminder email template | ☐ | | | `SBS_MAILTM` | `string(10)` | Subscription email template | ☐ | | | `SI1_MAILTM` | `string(10)` | Sales invoices email template | ☐ | | | `SO_COLD` | `string(40)` | Consolidated sales order description | ☐ | | | `SO_DESC` | `string(4)` | Consolidated sales lines description | ☐ | | | `SO_SPLIT` | `string(4)` | Split delivery description | ☐ | | | `SOI_COLD` | `string(40)` | Consolidated invoice description | ☐ | | | `SOI_DESC` | `string(4)` | Consolidated invoicing lines description | ☐ | | | `SOOC_MAILM` | `string(10)` | Order confirmation email template | ☐ | | | `TIT_FEM` | `string(30)` | Salutation female | ☐ | | | `TIT_MALE` | `string(30)` | Salutation male | ☐ | | | `TIT_UNKW` | `string(30)` | Salutation unknown | ☐ | |