G/L Account
Use this service to import G/L Account information.
Method: AddGLAccount
Underlying File Maintenance
Prior to importing G/L Account information, the following file maintenance areas must be completed:System AdministrationInstallationGeneral Ledger
System AdministrationInstallationGeneral LedgerG/L Department File Maintenance
System AdministrationInstallationGeneral LedgerG/L User-Defined Fields Maintenance
System AdministrationInstallationJob CostCost Type File Maintenance
Assumptions and Dependencies
The GL Account Master cost center flag is shared. The GL Account import will validate that the company has the cost center option set to Pending or Yes and will set the default for the new G/L Account to Shared.
If the Direct_Cost_Flag field is defined with a Y then the Cost_Type field is required.
All General Ledger accounts will post in detail.
Field Descriptions
Use the table below for reference when using this service. The Authorization_ID and GUID elements are not shown on the Spectrum Excel Office Add-in templates for data entry points.Excel |
Element Name | Description | Req | Type | Max | Format | Validation |
---|---|---|---|---|---|---|---|
Authorization_ID | Authorization ID to access the server | YES | Text | 20 | Data Exchange Installation Screen | ||
GUID | Unique reference number created by programming | Text | 36 | ** See GUID definition | |||
B |
Company_Code | Company Code | YES | Text | 3 | Valid company in Spectrum | |
C |
GL_Account | G/L Account | YES | Numeric | 12 | Verifies the GL mask and department prefix for the account code from install screen. Positive numbers only. | No dashes. |
D |
Description | Description | Text | 30 | |||
E |
Short_Description | Abbreviated Description | Text | 18 | |||
F |
Account_Type_Code | Account Type | YES | Text | 1 | (A)ssets; (L)iabilities; (C)apital; (I)ncome; (E)xpense; or (S)tatistic only | |
G |
Direct_Cost_Flag | Direct Cost | YES | Text | 1 | (Y) - Direct Job; (E) - Direct Equipment; or (N) - Non-Direct only; (W) - Work Order | |
H |
Cost_Type | Cost Type | Text | 3 | Required if Direct_Cost_Flag = Y | Cost Type Master | |
I |
Status | Status | YES | Text | 1 | (A)ctive; (I)nactive; or (N)ot Used only |